View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sol Apache Sol Apache is offline
external usenet poster
 
Posts: 8
Default Replacing a date in date format.

Hi Bart

I only want to change dates in table headers. It would be difficult to do it
the way you have suggested.

Thx

Oz


On 12/7/07 15:03, in article
, "Bart"
wrote:

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