Ann
11/03/2004 was a Thursday.
How did you get Saturday?
That date exactly 1 year later will be a Friday.
Do you mean the closest Saturday or the actual weekday 1 year later?
See Peo's reply.
Gord Dibben Excel MVP
On Fri, 4 Mar 2005 10:11:46 -0800, "Ann Shaw" wrote:
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
|