#### 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

Options
edited 12/09/19

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

so eg

=Today +5 months

• ✭✭✭✭✭✭
Options

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.

=DATE(YEAR(TODAY()), MONTH(TODAY()) + 3, DAY(TODAY()))

• Employee
Options

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

This discussion has been closed.