View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Is there a way to change all dates in a spread sheet

editreplace0607

--
Don Guillett
SalesAid Software

"delete automatically" wrote
in message ...
I have a spread sheet with dates for the whole year of 2006. Exmaple I have
1/1/06 thru 1/15/06 in the first 14 rows. Then rows 15 thru 20 have other
data. Then start with 1/16/06 thru 1/29/06 then more data. How can I
changed
the dates to the right dates of 2007 without gong to each block of dates.