IF function that depends on a date

[Pointer]

In cell A1 I have a date. The date is not in text form but is
formatted as a date.

If the date is 7/4/04, I want cell B1 to say "The Fourth". If A1 is
not 7/4/04, cell B1 should read "No holiday".

How can I do this?

 

[Paul B]

Pointer, try this in B1
=IF(A1=DATEVALUE("07/04/2004"),"The Fourth","No holiday")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[cooldude]

i know this works:

=IF(7/4/4,"The Fourth","No holiday")

but only on the same cell, i'll play with it and see if i can make it work
on the B1 cell.

 

[Pointer]

That works fine. Thank you!