Date Function

  • Thread starter Thread starter HARSHAWARDHAN. S .SHASTRI
  • Start date Start date
H

HARSHAWARDHAN. S .SHASTRI

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
 
try this,

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

Mike
 
Look at the WORKDAY function, you obviously need to create a list of public
holidays and incorporate it
in the formula


=WORKDAY(A1,3,holidays)

where A1 is the date, 3 is the number of days and holidays can be a named
range with public holidays or just a range e.g. H2:H10

Unless you are using Excel 2007 WORKDAY is not installed by default but it
comes with the Excel/Office CD
so if you get a name error go to tools>add-ins and select Analysis ToolPak
and follow the instructions (keep the CD handy)

--


Regards,


Peo Sjoblom

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

Harshawardhan Shastri

===========================================================
 
You need Analysis ToolPak installed, see my answer to you

--


Regards,


Peo Sjoblom

"HARSHAWARDHAN. S .SHASTRI"
 
I can heartily recommend the use of the Excel help function. Type in the
word WORKDAY, and see what it tells you.
 
It didn't look as though the OP wanted to skip weekend dates, but we shall
await a response.
 
Back
Top