Date duration subtraction

Zane Fielding

Not sure how to explain this. I have attached a photo of how its done in Excel and the actual smartsheet.

I have a migration state date of July 28th and several tasks after. I need the cell in start time to change if I decrease or increase the lead time. I cant figure out any formula or if its even possible.

Excel Example

Smartsheet

Jaykel Torres

Hey @Zane Fielding,

It looks like you are trying to subtract a date from a number and return the resulting date. I have created an example below on how this formula may look like:

• Formula: =$[Migration Start Date]$1 - [Lead Time]@row

Take note that the "$" signs are used to create Absolute References.

I hope this helps!

Jaykel

Zane Fielding

@Jaykel Torres I am actually trying to subtract a number from a date and return the resulting date.

Zane Fielding

@Jaykel Torres I tried the above formula and got a #INVALID OPERATION

Genevieve P.

Hi @Zane Fielding

Were you able to find a resolution to your question or are you still working on this?