Dates formula : add several months in a formula

Corentin Dal Farra

Hello everyone,

I have a small question about the use of Smartsheet for a formula on dates. Here is the use case :

I have a column with a date. I would like to have another column with a formula that add 3 months to that date.

I already try =DATE(column)+90 but it only add 90 days and sometimes 90 days is not exactly a 3 months duration. Do you know if it is possible in Smartsheet ?

Thank you very much,

Corentin

David Joyeuse

Hi @Corentin Dal Farra

You should be good with:

=IFERROR(DATE(YEAR([Date]@row, MONTH([Date]@row)+3, YEAR([Date]@row)), DATE(YEAR([Date]@row +1 , MONTH([Date]@row)-9, DAY([Date]@row)))

Hope it helped!

David Joyeuse

Hi @Corentin Dal Farra

You should be good with:

=IFERROR(DATE(YEAR([Date]@row, MONTH([Date]@row)+3, YEAR([Date]@row)), DATE(YEAR([Date]@row +1 , MONTH([Date]@row)-9, DAY([Date]@row)))

Hope it helped!

Corentin Dal Farra

Hello @David Joyeuse

It works perfectly, thank you very much for your help on this pain point !

Have a great day,

Corentin

JayF

I'm trying to do the exact same thing and it keeps saying incorrect argument. My first date column was "date hired" so I changed [date] to [date hired] and my second column is labelled 3 month mark. @David Joyeuse im stuck any help would be appreciated