convert existing range of dates to to current year, maintaining mm

  • Thread starter Thread starter Lin24
  • Start date Start date
L

Lin24

Excell 2007 - New user

Can someone help me with the formula to keep a range of dates with the same
month and day, but update the year to the current year?

I need to keep the month and the day of the month that a client received
certification however they will be required to recertifiy each year by that
date. So I need the year to be the current year...
 
Hi

With original date in A1 use this formula:

=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

Regards,
Per
 
Hi again...another question. What if I want the year to be next year (2010),
or 2011...for planning?
 
Hi again, you can just add 1 to the year (2):

=DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1))
 
Back
Top