I have a list of sequential dates in column A; let's 12/01/05 (Dec 01, 05) to
12/31/05. I want to use a conditional if statement to evaluate if the date
is less than a given day, for example: =IF(A1<12/15/05,"Less","Greater").
Therefore the first 14 should result in "Less" and the last 17 should result
in "Greater". My reslut is returning "Greater" for all of them. Any ideas
why? Two additional things: 1st, if I put the date in column B and then do
=IF(A1<B1,"Less","Greater") then it works fine, its only a problem when I
enter it manually. 2nd, this would be fine, but I'm trying to use a Macro
with an Input box where I enter the date (a variable) which slots into my If
statement. Any suggestions?

Thanks.