Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Advanced Date functions

Anyone know whether I can use functions to add a number of months to a date


so eg

=Today +5 months




  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    I don't know of an easy way to do what you want but it's probably possible with a very complex date formula. The simple formula below works as long as the month doesn't go over 12 (December) so I entered 3 instead of 5 for the month, and today is not the 31st and adding the months doesn't end up on a month with either 28 or 30 days. To generate a formula that coped with MONTH(TODAY() +n being greater than 12 and with today being the 31st would involve a complex IF function for Year, Month and Day in the DATE function. Probably not practical. Maybe someone else has a better idea.



  • Travis
    Travis Employee

    Check out this thread where Brett offers a solution for this: https://community.smartsheet.com/discussion/date-formula-help

This discussion has been closed.