Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
If all dates are numeric dates and they are all 2004 dates, put 366 in a
cell, copy it, select all dates <= Feb 29 2004 and do editpaste special and select add, reformat as dates because you will probably get a serial number. Put 365 in a cell, copy it and select all dates = Mar 01 2004 and repeat. Or use a help formula =DATE(YEAR(B1)+1,MONTH(B1),DAY(B1)) copy as much as needed, select and copy and paste special as values, note that a date like Feb 29 2004 will be Mar 01 2005, if you want Feb 28 2005 edit that particular date or add 365 days to it -- Regards, Peo Sjoblom "Ann Shaw" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |