change date

  • Thread starter Thread starter Oldjay
  • Start date Start date
O

Oldjay

I have a list with dates
8/18/05
I want to change them to 8/18/06
I tried using the find and replace
i.e. find ?/?/2005
replace ?/?/2006
it finds the cells but replaces with ?/?/2006
What do I put in the replace to leave the month and day alone?
oldjay
 
Even though the dates display as 8/18/06...if you check the formula bar,
you'll see that that date is actually 8/18/2006. So, try this:

Select your date range
Edit>Replace
Find what: /2005
Replace with: /2006
Click [Replace All]

Does that help?

***********
Regards,
Ron
 
oldjay,

If they are truly dates, then simply type 365 into blank cell, copy it, select the cells with the
dates, and select pastespecial, add, values, ok.

HTH,
Bernie
MS Excel MVP
 
oldjay

Just replace the 2005 with 2006.

Excel is smart enough to make the change.

For experiment try this.

Format 8/18/05 as dddd and returns Thursday

Now change 05 with 06.

The dddd will change to Friday which is 8/18/06


Gord Dibben Excel MVP
 
Ctrl -H

Replace 05 with 06

Ok

:o)

--
@---}--
Laura..... :)
Liverpool, England

: I have a list with dates
: 8/18/05
: I want to change them to 8/18/06
: I tried using the find and replace
: i.e. find ?/?/2005
: replace ?/?/2006
: it finds the cells but replaces with ?/?/2006
: What do I put in the replace to leave the month and day alone?
: oldjay
:
:
 
Back
Top