EDATE, why is this not a function?

MelSTep

Hello,

I have read several threads of people asking for this function. I am actually shocked this is not available. I need to calculate a date 45 days out from an approval date. I have tried several formulas and nothing is working. Please help..

Toufong Vang

Hi, @MelSTep,

In Smartsheet, 45 days out from any date is "Any_Date + 45". So the formula in Due Date is

=[Approval Email]@row + 45

You can find a list of all Smartsheet functions and documentation here, https://help.smartsheet.com/functions

Cheers!

Toufong Vang

Hi, @MelSTep,

In Smartsheet, 45 days out from any date is "Any_Date + 45". So the formula in Due Date is

=[Approval Email]@row + 45

You can find a list of all Smartsheet functions and documentation here, https://help.smartsheet.com/functions

Cheers!

MelSTep

Thank you!! I wasn't putting in the ] at the end face palm..