Count in Reverse the Number of Days from a Target Date (TD-X)

[isadoko]

I need count backwards from a date, eg, 3/16/18. I have entered a dateline starting B2 (2/16/18) through AD2 (3/16/18)--AD2 is my target date. Am looking for something like TargetDate-1 (TD-1)..TD-2, TD-3, etc, all the way back to B2 (2/16/18) or TD-28. Would appreciate a formula that counts backwards and displays as I've written it TD-X. Thanks.

 

[isadoko]

So worked out this =Concatenate($AD$2,"-",AC2-$AD$2). However, must extend timeline to 9/16/18. Given longer timeline how then to know when in dragging back from FH2 will it know that a particular cell contains a target, ie, TD-X, and so not count it but instead recognize it as target and resume count backward one cell to the left. Targets and cells, after AD2 are: BI2, CM2, DR2, EV2, GA2 and HF2.

 

[jtakw]

Hi,

If you add a Header on the column(s) where it contains a "Target Date", then you can incorporate it in a formula.

 

[isadoko]

Do you mean something like =CONCATENATE(AD2,"",AD2-$AD$2)? I tried and simple but works--did not think of that. Will carry it to conclusion and see what comes of it. Thanks!

 

[isadoko]

Hitch... When target date changes, ie, TD1 to TD2 formula return nonsense...TD10 and next TD range starts with TD21. Need work out the transition.

 

[jtakw]

Can you show some sample data and what you want done, please.
It's difficult to come up with a formula not knowing how your data is.