need column to reflect year 2008 dates
 

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

need column to reflect year 2008 dates
 

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

need column to reflect year 2008 dates
 

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?

need column to reflect year 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

need column to reflect year 2008 dates
 

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

need column to reflect year 2008 dates
 

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

need column to reflect year 2008 dates
 

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?