Holiday
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")
--
Biff
Microsoft Excel MVP
"Farhad" wrote in message
...
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!
--
Farhad Hodjat
|