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

Matthew Dickinson
Matthew Dickinson ✭
edited 12/09/19 in Archived 2015 Posts

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

 

so eg

=Today +5 months

 

 

· Share on FacebookShare on Twitter

Comments

  • 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.

     

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

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories