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

Excel Vba to change displayed year automatically. 14
Hello happy new year to all, Text box input for year of purchase 0
Access 2 Digit year in Access Text Box 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT 8
Calculating monthly totals for current and previous year 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Error on Query with DateSerial() 0

Top