formatting has no effect on what is stored in the cell. It appears you have
a text string stored in the cell. You will have to parse out the date
portion and convert it to a date if you need a date serial number.

--
Regards,
Tom Ogilvy


"sbowman" wrote:

Darn it, using variant doesn't work for me because i have to do
comparisons later on in the code (less than, equal to, etc.). The cells
I'm referencing are formatted as dates but some of them do have some
text in them which may be throwing off my code. I really need to dim as
date, help!!!

Shelley