You need Analysis ToolPak installed, see my answer to you

--


Regards,


Peo Sjoblom

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
It does not works.Showing #NAME?.This formula (Workday) is not there in
function list.

Harshawardhan Shastri

================================================== =========

"Mike H" wrote:

try this,

Add 3 working days to a1. Holidays is a named range that contains any
national holidays
=WORKDAY(A1,3,Holidays)

Mike

"HARSHAWARDHAN. S .SHASTRI" wrote:


I have a work sheet in which column A is having "Recd On" (Date).
column B
is having "Dispatch On" (Date). If there is no holiday Dispatch On date
=
Recd On Date +3 . Column H is having list of dates on which there is
holiday.
What i want is a formula which will give me Dispatch Date which is not
a
holiday. For example if recd date is 24/09/2008 and there is holiday on
27/9/08,28/9/08,30/9/08 then Dispatch Date should be 01/10/08.

Harshawardhan.Shastri

India