Thread: Formula
View Single Post
  #1   Report Post  
Ann Shaw
 
Posts: n/a
Default Formula

I have a spreadsheet that has dates intact from 2004
How could I change the dates to show the same date for
2005.

Example:

Day Date Name Task
Sat 11/3/2004 Joe Bloggs Sales
Sat 18/3/2004 Ben Dunne Testing

I would like the same sheet to show in column B which
holds date, to show the Sat date exactly 1 year later 2005