Find and replace date in a work sheet

**pohaku** · 11-18-2007, 12:25 PM

I have this date format 1-Jan to 31-Jan in a column, I try to use the Find & Replace to change it to 2-Feb to 28-Feb but Excel box said cannot find any data to replace. Anyone help please.

**oldchippy** · 11-18-2007, 12:29 PM

Why not just edit the first date to 01/02/2007 and drag that down the column

**VBA Noob** · 11-18-2007, 12:31 PM

Excel stores a date as a number so 1/1/07 = 39083 so you can't use find.

Not clear from your post what your doing. Maybe you could enter 1/1/07 in cell A1 then In B1 enter =A1+1 and drag across.

To change month just need to change A1 from 1/1/07 to 1/2/07

HTH

VBA Noob

**pohaku** · 11-18-2007, 12:52 PM

I have this monthly sheet and have about quite a lot of column using the date like 1-Jan to the end of the month, about 10 set of this, when I create another sheet for Feb, instead of retype all this, hope to use the Find & Replace to do all the change of Jan to Feb.

**pohaku** · 11-18-2007, 12:54 PM

Have to go Hiking, will be back later, thanks

**pohaku** · 11-18-2007, 05:44 PM

I Had changed the format from date to text and able to use the Find & Repace to do the month change. Thanks for the help again.

**VBA Noob** · 11-18-2007, 05:51 PM

Good to hear

Another way would have being to enter 31 in a blank cell then copy select say Jan dates then Right click > Paste special > add

VBA Noob

**pohaku** · 11-18-2007, 07:25 PM

Thanks a lot!
can you help me on a new thread? "unprotect cells"

Find and replace date in a work sheet

LinkBack

Thread Tools

Rate This Thread

Display

Find and replace date in a work sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions