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

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

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

Hi

With original date in A1 use this formula:

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

Regards,
Per

"Lin24" skrev i meddelelsen
...
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...

convert existing range of dates to to current year, maintainin
 

Thank you so much!

"Per Jessen" wrote:

Hi

With original date in A1 use this formula:

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

Regards,
Per

"Lin24" skrev i meddelelsen
...
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...

.

convert existing range of dates to to current year, maintainin
 

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

"Per Jessen" wrote:

Hi

With original date in A1 use this formula:

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

Regards,
Per

"Lin24" skrev i meddelelsen
...
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...

.

convert existing range of dates to to current year, maintainin
 

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

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

---
Per

"Lin24" skrev i meddelelsen
...
Hi again...another question. What if I want the year to be next year
(2010),
or 2011...for planning?

"Per Jessen" wrote:

Hi

With original date in A1 use this formula:

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

Regards,
Per

"Lin24" skrev i meddelelsen
...
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...

.