View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EllenM EllenM is offline
external usenet poster
 
Posts: 78
Default Update Timecard to new year

Hello,
I'd like to update a time card file to the 2008. It contains 26 worksheets,
each worksheet contains 14 dates.

For example 1/2/07 would become 1/1/08. For dates after Feb 28th, for
example 3/5/07 would become 3/3/08.

Is there a formula that would make these conversions? Sounds like I'd need
one for before Feb 28th and a second for after Feb 28th.

Thanks in advance.

Ellen