Date Function
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
|