Menu

Date Question

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

Date Question

posted in misc

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"onliner" wrote in message
news:xPNYa.40496$Ne.17248@fed1read03...
I have downloaded data which contains a column of review dates. The dates
are formatted as mm/dd/yyyy.
I have code that expects the date to always be 8 digits (and apparently
text) in the form of, "05152004".
The current code treats the month segment as
=If(Left(A1,2)="05", Then do something...
which currently fails for months 1 thru 9.
I know I could do; =If(Month(A1)=5, etc. but this would involve finding
and
replacing every instance of the existing date-handling code. I was hoping
that I could perform a one-time vba procedure on the date column that
stepped thru each cell in the column and converted the existing date to an
8-digit text string such as 05152003 and have this "non-date" be stored as
the value in each cell.
Is there a way to do this?
Thanks,
Bud

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DATE question	WLMPilot	Excel Worksheet Functions	2	January 20th 09 09:42 PM
Date Question	Pat Rice	Excel Worksheet Functions	3	October 30th 08 03:08 PM
Date question??	kk	Excel Discussion (Misc queries)	13	March 14th 08 01:53 PM
Date question	Jman	Excel Worksheet Functions	8	June 1st 07 10:43 AM
Date Question	scwilly	Excel Worksheet Functions	3	April 26th 06 09:24 AM

All times are GMT +1. The time now is 11:36 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement