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!

rspahitz

How about using this formula (assuming the deadline date is in A1 and this formula is in B1):

="T"&IF(A1>NOW(),"-","+")&ABS(ROUND(A1-NOW(),0))&" days"

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

jquestion

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

ASKER CERTIFIED SOLUTION

rspahitz

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

jquestion

ASKER

Awesome, it works perfect thanks!!!

rspahitz

Great! glad to help.