View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lin24 Lin24 is offline
external usenet poster
 
Posts: 3
Default 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...