Changing to new dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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.
 
-----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
 
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
 
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.
 
Back
Top