This works for the following dates:
Start Date: 01/05/18
End Date: 30/04/18
Contract Length: 12 (months)
Start Date: 03/05/18
End Date: 06/05/19
Contract Length: 13 (months)
However, does not work for the same date of the next month.
e.g.
Start Date: 03/05/18
End Date: 03/05/19
Contract Length should be 13 months (1 year and one day) however, comes out as 12 months
6 respuestas
Hi Serena Shergill,
Please update your formula like below,DATE( Year([start date])+floor((MONTH([start date]) + [# of months] - 1) / 12) ,
mod(MONTH([start date]) + [# of months] -1, 12) + 1 ,
day([start date])
) - 1
Thanks,
Krutarth Soni
