Doing Date Comparisons

J

Jason

I have specific ranges of dates, such as between 1/1 and 1/10 of a given year, and I want to know if a date entered falls between those dates. However, as I mentioned, I have a range of dates so I need to scan all of the dates in the range before I get a true or false. Any ideas?
 
F

Frank Kabel

Hi
does your range of dates consist of 'real' Excel dates. Your example of
'1/1' seems to idnicate either a custom format or a text value?
 
Top