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