hi,

I received an Excel file with a formula inserted to compare a day with a
date; if the day is more than or equal to 15, then the formula will return
Yes; i think so.
The formula is =IF(Day(A1)=DATE(2005,1,15),"Yes","No") & the date in A1 is
1/15/06 & the value returned is No.

Actually, the answer sounds weird to me cause it should return Yes instead
of No. Plus, I did try to change the sign in the IF function to < sign then
the answer returned was Yes. So, what is all these mean? Is it possible to
compare in this way or the formula is built up with logical error? Could
anyone help?

Thanking in advanced.