Will any of the dates for your holidays ever occur on a weekend? If **not**,
you could use NETWORKDAYS to calculate the number of holidays occurring
between your start and end dates by subtracting a NETWORKDAYS function call
with a reference to your holiday list from a NETWORKDAYS function call
without a reference to the holiday list... and subtract that number from the
difference between your start and end dates plus 1 (to include both the
start and end dates in your count). For example,

A1: Start Date
A2: End Date
H1: Start Holiday List
H9: End Holiday List

=A2-A1+1-(NETWORKDAYS(A1,A2)-NETWORKDAYS(A1,A2,H1:H2))

Remember, though, this assumes no holidays will take place on a weekend.

--
Rick (MVP - Excel)


"Jock" wrote in message
...
Exactly! I want it to include weekends, not ignore them.

I.E. 14 days from 01/01/09 will be 14/01/09 not 21/01/09 as it is using
WORKDAY
--
Traa Dy Liooar

Jock


"Stefi" wrote:

You are wrong! WORKDAY does take care both of weekends and holidays!
Check it
again!

Regards,
Stefi

€žJock€� ezt Ã*rta:

Hi,
I need to have a date formula which will not ignore weekends and will
take
into account a list of holiday dates.
WORKDAY takes care of the holiday list but ignores weekends.
Is there another function that will include weekends AND holidays?
p.s. any weekends within the holiday dates can be ignored.

Thanks
--
Traa Dy Liooar

Jock