How do I calculate dates from a cell whose value is based on a Formula?
I have a cell I would like to calculate a date that is based off another date minus the value of another cell that is calculated off a separate formula.
So I did =[Install Date]@row - [Projected Lead time]@row
The issue seems to be that [Projected Lead time]@row is a calculated =IF formula whose value is in number format. If I select any other cell [Number Format] that has a number format but doesn't have a formula, the formula =[Install Date]@row - [Number Format]@row works just fine.
Help Article Resources
Check out the Formula Handbook template!