Calculations with dates

Hi there, I have an issue that I am not getting right.

I have this: (for example)
Start date → 2020/06/08
End date → 2022/06/08
I managed to calculate the term is 24 months, now I need to calculate 24 months from a specific date in another field.
Say → 2020/08/05

Can anyone please help.

Much thanks
Dx

Are you trying to count 24 months from that new start date?

How would you handle leap years? For example, if the date is Feb 29th, what would you expect after 24 months when you have a February with only 28 days?

Refer to the two ‘Add m Months’ formulas in the following post. The formula you use depends on your answer to the above question.

3 Likes

Yes.