Holidays

E

edwardpestian

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
 
M

monahmat

You could do a Data Merge using a web query to get all the yearly
holidays off of the web and then do a Lookup off of the table. That
way you wouldn't have to enter all of the holidays in by hand and it
would update every year without you haveing to worry about it,
especially usefull for holidays like mothers day, fathers day and
easter that aren't on the same days every year.
 
Top