Hi board members, I am sure someone can assist me please.
I have a date i.e 08/01/2013 (dd/mm/yyyy format). In an adjacent cell I need to work out a date that is 6 years
following the expiry of that current calendar year.
So 08/01/2013, will show 31/12/2013 + 6 years = 31/12/2019
Many thanks...