Help me with Excel 97

[marreia]

I created a list that contains 2000 records that have date issued for each record. now i want to change the month from Aug to Sep without changeing the date and year.
For example: from 1-Aug-2001 to 1-Sep-2001
the date is in date format.
Please help me.

 

[ETID]

Try this:

where cell A1 = your fist date


=DATEVALUE(MONTH(A1-1)&"/"&DAY(A1)&"/"&YEAR(A1))

be sure to format this colum the same as your orig. date

then copy and paste.


hope this helps

 

[ETID]

ooops...you want to add a month so it's this

=DATEVALUE(MONTH(A1+1)&"/"&DAY(A1)&"/"&YEAR(A1))

 

[ETID]

Sorry...brain dead today ignore those two formulas
this is what i meant


=DATEVALUE(MONTH(A1)+1&"/"&DAY(A1)&"/"&YEAR(A1))

 

[ETID]

if you need to change dec to jan then use this formula

=DATEVALUE(IF(MONTH(A3)=12,1,MONTH(A3)+1)&"/"&DAY(A3)&"/"&YEAR(A3))