Hi!
When Excel stores a date it does it as an integer counting from 1 Jan
1900 (=1) normally.
Your comparison needs to be done using similar numbers.
Put 30/09/2005 in a cell and it will look just like that.
Now reformat it as General and it will read 38625.
This gives you a simple way of "translating" between the number as
stored and the date as viewed.
That's fine on the worksheet but you need the integer form in the VBA.
Alf
--
AlfD
------------------------------------------------------------------------
AlfD's Profile:
http://www.excelforum.com/member.php...fo&userid=4785
View this thread:
http://www.excelforum.com/showthread...hreadid=474279