Hi,
can any one help me witht he formula to calculate one year from the the given date?
I have a date in cell B2. 01-01-2019 (DD-MM-YYYY format)
In C2, I need a result as 31-12-2019 (DD-MM-YYYY format). It shoud change automatically if I chage the date in B2. More examples as below
If I enter 25-03-2019 then the result should be 24-03-2020
If I enter 12-10-2019 then the result should be 11-10-2020
Bookmarks