Can Excel return the name of a holiday based on the date. For example
if U4 containted the date 07/04/2006, can Excel return 4th of July. I
realize I could do this with a VLOOKUP function and enter all the
holidays of the year in a column next to the corresponding date;
however is there a way for Excel to do it automatically?

Thanks in advance.

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=564574