Holiday

[Farhad]

Hi,

I am using Excel 2003 is there a function that read a date from a cell and
recognize if the date is a holiday?

Thanks for help!

 

[Eduardo]

Hi,
take a look to CPearson web related to Holidays

http://www.cpearson.com/excel/holidays.htm

if this helps please click yes thanks

 

[T. Valko]

You have to tell Excel what dates are holidays.

If you list the dates that are holidays in a range of cells like X1:X10 then
you can compare the cell with the date to those holiday dates.

A1 = some date

=IF(COUNTIF(X1:X10,A1),"Holiday","Not a holiday")