Hi,
I have a certain date, e.g. 25/03/2011 in column A. In column B, I would like to have a formula that gives the same date, e.g. 5 years later. In the example, it would be 25/03/2016.
In column C, I would like to have a formula that gives the first of January of the year following the year in column B. So that would be 01/01/2017.
How do I do this ?
Thanks !
Bookmarks