View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bart[_6_] Bart[_6_] is offline
external usenet poster
 
Posts: 37
Default Replacing a date in date format.

I played with the Find & Replace functions. Couldn't get it to work.
Are those dates particular dates or do you want to change all dates.
Because you could add 61 days like:

B1: "=A1 + 61"

where A1 is the cell with the date to be changed. ('B1:' is de target
cell)

Bart