jquestion

asked on

# Calendar Tracker

Hello All!

I have a question. I want to make my life easier for deadlines and dates on a process I am in charge of. scenario:

TriggerDay 04 - 01

Process Due for TriggerDay

T-35 days

T-15

T-5

T+5

T+10

Problem is I have 2 Trigger Days a month!

I would like something that I could enter in the TriggerDate and it gives me my Tdates?

Maybe you can think/suggest of something better?

Thanks!

I have a question. I want to make my life easier for deadlines and dates on a process I am in charge of. scenario:

TriggerDay 04 - 01

Process Due for TriggerDay

T-35 days

T-15

T-5

T+5

T+10

Problem is I have 2 Trigger Days a month!

I would like something that I could enter in the TriggerDate and it gives me my Tdates?

Maybe you can think/suggest of something better?

Thanks!

ASKER

Ok, that was good, thanks! Not exaclty what I need. It made me think more. So say I have this below scenario.

Column

A1 or dropdown A TargetDate

B DATES

C OUTPUT

It pulls the target dates based on a count. Or I can use a variation of the forumla above(using column b dates and not the NOW) and drag it down column c.

Tdates.xlsx

Column

A1 or dropdown A TargetDate

B DATES

C OUTPUT

It pulls the target dates based on a count. Or I can use a variation of the forumla above(using column b dates and not the NOW) and drag it down column c.

Tdates.xlsx

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Awesome, it works perfect thanks!!!

Great! glad to help.

="T"&IF(A1>NOW(),"-","+")&

Here's what I came up with using that formula for April 5

1-Jan T+95 days

15-Jan T+81 days

1-Feb T+64 days

15-Feb T+50 days

1-Mar T+36 days

15-Mar T+22 days

1-Apr T+5 days

15-Apr T-9 days

1-May T-25 days

15-May T-39 days

1-Jun T-56 days

15-Jun T-70 days

1-Jul T-86 days

15-Jul T-100 days

1-Aug T-117 days

15-Aug T-131 days

1-Sep T-148 days

15-Sep T-162 days

1-Oct T-178 days

15-Oct T-192 days

1-Nov T-209 days

15-Nov T-223 days

1-Dec T-239 days

15-Dec T-253 days