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

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

Per Jessen

Hi

With original date in A1 use this formula:

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

Regards,
Per
 
L

Lin24

Hi again...another question. What if I want the year to be next year (2010),
or 2011...for planning?
 
P

Per Jessen

Hi again, you can just add 1 to the year (2):

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Creating a Search using a combo box and then creating a report. 4
Date Time decimal value help please 1
Dynamic border formatting based on dates. Use VBA? 1
Calendar Logic: Recurring Dates 3
Loop Macro to edit Date 0
Displaying two dates in excel 1
Help with determining # of days from certain dates 2

Top