How do I calculate dates from a cell whose value is based on a Formula?

Josh Whittlesey

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.

Any thoughts?

Mike TV

@Josh Whittlesey

Try doing:

=[Install Date]@row - VALUE([Projected Lead Time]@row)

Mike TV

@Josh Whittlesey

Try doing:

=[Install Date]@row - VALUE([Projected Lead Time]@row)