Advanced Date functions

Matthew Dickinson

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

 

so eg

=Today +5 months

 

 

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.

 

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