Hi,

Workday has an optional parameter called holidays

=WORKDAY(A1,B1,holidays)

Where holidays is a named range containing holiday dates
Mike

"Clareabella" wrote:

I am using the workdays formula in excel. It works fine with the exception
of months where there are bank holidays it doesn't seem to be recognising
them. I assume it is not seeing some form of calendar so how to I activate
the calendars in excel (the calendar in outlook is fine and all bank holidays
are showing) ?
--
Clareabella