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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack B" wrote in message
...
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

Don,

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


Jack



"Don Guillett" wrote in message
...
try this
Sub replaceyearindate()
Columns("e").Replace "2009", "2008"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack B" wrote in message
...
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

Another play ..
If the source dates are in B1 down,
put in C1: =DATE(YEAR(B1)-1,MONTH(B1),DAY(B1))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Jack B" wrote in message
...
.. 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?

Max

Missed your posts.

Where have you been?


Gord

On Fri, 1 May 2009 07:24:37 +0800, "Max" wrote:

Another play ..
If the source dates are in B1 down,
put in C1: =DATE(YEAR(B1)-1,MONTH(B1),DAY(B1))
Copy down

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
---
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Max

Missed your posts.

Where have you been?


Gord

Max,

Okay, that worked -- thanks!


Jack



"Max" wrote in message
...
Another play ..
If the source dates are in B1 down,
put in C1: =DATE(YEAR(B1)-1,MONTH(B1),DAY(B1))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Jack B" wrote in message
...
.. 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?