Dynamic Future Date based on Condition

11/21/18 Edited 12/09/19

Hello, 

Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: 

If Phase is "SOW Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be 60 days, but tomorrow it will be 59, and so on). 

I've tried multiple formulas, but nothing really comes close to what I need. I can use an IF formula, but the main problem I have is with the dynamic date. 

Any help or guidance is greatly appreciated. Thank you.

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    How many different phases do you have? If it is only a few, a nested IF statement would work. If you have more than a few, I would suggest setting up a table and using an INDEX/MATCH formula.

    thinkspi.com

Sign In or Register to comment.