IF function that depends on a date

  • Thread starter Thread starter Pointer
  • Start date Start date
P

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?
 
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 **
 
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. :)
 
Back
Top