Date Formula Problem

11/30/19 Edited 12/09/19

See attached.    I am having problems with the date  date formula.   I add 12 months to the moths and the year does not change.  

 

The formula is set up to add # of months(MONTHS) to the start date (SDATE) to calculate and populate  the end date (EDATE).  It seems the formula works so long as the start date and end date are in the same year.   Most of my calculation will include two or more years.

 

 

45.JPG

200_0.JPG

201.JPG

Tags:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Tom,

    Which formula are you using?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

     

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.