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
Comments
-
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()))
-
Check out this thread where Brett offers a solution for this: https://community.smartsheet.com/discussion/date-formula-help
