Changing to new dates

A

Ali

Hi everyone
I am trying to change last year of date to new year i.e from 2003 to 2004.I have done them day by day and if i start changing date i have to do for 365 days .Can any one tell me how can i change those years
e.g 01/01/0
02/01/03
this goes up to 31/12/0
and i want it to be changed to 2004 year
plz help me im going crazy!!!
 
P

Peo Sjoblom

Just put the first date in the first cell

assume it is A1, in A2 put

=A1+1

then just copy down the formula



--

Regards,

Peo Sjoblom

Ali said:
Hi everyone,
I am trying to change last year of date to new year i.e from 2003 to
Click to expand...
2004.I have done them day by day and if i start changing date i have to do
for 365 days .Can any one tell me how can i change those years.
 
P

Peter Atherton

-----Original Message-----
Hi everyone,
I am trying to change last year of date to new year i.e
Click to expand...
from 2003 to 2004.I have done them day by day and if i
start changing date i have to do for 365 days

Ali

One Way start from scratch and in a1 type 1/1/04.
in A2 type =A1+1. Copy this formula down to row 366. Then
next year you can just change the date in A1 and delete
the last entry.

Regards
Peter
 
G

Gord Dibben

Ali

Select the range then Edit>Replace

what: 2003
with: 2004

Assuming, of course, these are real dates and not text as 01/01/03

Gord Dibben Excel MVP
 
P

Peo Sjoblom

You also have to insert a row and add 02/29/04 in that row

--

Regards,

Peo Sjoblom

Gord Dibben said:
Ali

Select the range then Edit>Replace

what: 2003
with: 2004

Assuming, of course, these are real dates and not text as 01/01/03

Gord Dibben Excel MVP
Click to expand...
2004.I have done them day by day and if i start changing date i have to do
for 365 days .Can any one tell me how can i change those years.
 
Top