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

Hi,
take a look to CPearson web related to Holidays

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

if this helps please click yes thanks

"Farhad" wrote:

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

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