need column to reflect year 2008 dates

  • Thread starter Thread starter Jack B
  • Start date Start date
J

Jack B

Re Ofc Pro 97 --

I re-worked part of a check book for 2008.

Now I realize that my dates which show up in the column, for instance, like
4/23, actually have a 2009 date (4/23/2009) instead of a 2008 date.

How do I get the entire column to reflect 2008 dates?


Jack
 
Thanks Gord. Dang, its my current work. As a full-time cabbie, I've got to
keep my eyes fully focused on the roads. Hope to be able to re-participate
more, once more, perhaps at a future point in time. Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
 
Don,

Don't understand how to apply this. That is, what cell do I put that in?


Jack



try this
Sub replaceyearindate()
Columns("e").Replace "2009", "2008"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

group of dates 1
Date between date range 1
FORMULA NEEDED FOR MONTHS 1
date into current and previous quarters 3
Question about modifying dates 3
Attempting to compare and deduct values based on date codes 3
Changing worksheets to the next years dates 2
YEAR MONTH DAYS COUNTER 3

Back
Top