Dynamic Future Date based on Condition
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.
Help Article Resources
Check out the Formula Handbook template!