You would need to have a list of your holidays on a worksheets. Assume this
is named Holiday

assume you have a list of dates to check in column A of another sheet with
the first date in A2

in B2 you could put

=if(iserror(match(A2,Holiday,0)),"","Holiday")

Drag fill this formula down the column.

If you wanted it in code

with Worksheets("Dates")
set rng = .Range(.Cells(2,1),.Cells(2,1).End(xldown))
End with
for each cell in rng
res = Application.Match(cell.Value,Range("Holiday"),0)
if not iserror(res) then
cell.offset(0,1).Value = "Holiday"
end if
Next

--
Regards,
Tom Ogilvy

wrote in message
om...
Hi gang....

Is there a way for EXCEL to tell me if a date is a stautory holiday (
Good Friday, Easter Monday, Christmas etc... ) ?

Basically I want some way to search a list of dates and have excel
tell me which dates are holidays.