Holiday

F

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!
 
T

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")
 
Top