Dates formula : add several months in a formula


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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!