Date Formula Problem

tom.dusnmore112871

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.

 

 

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