Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Anyone know whether I can use functions to add a number of months to a date
so eg
=Today +5 months
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
