Holidays
 

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

Holidays
 

How would excel know which holiday is when?
I think you need to use VLOOKUP only.

"edwardpestian"
wrote in message
news:edwardpestian.2bhl0z_1153806304.2522@excelfor um-nospam.com...

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

Holidays
 

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.

Gary wrote:
How would excel know which holiday is when?
I think you need to use VLOOKUP only.

"edwardpestian"
wrote in message
news:edwardpestian.2bhl0z_1153806304.2522@excelfor um-nospam.com...

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