How many days

Hello All,

How do I calculate how many working days between two
dates. Using the UK holiday calender, I have a list of
additional holiday dates that are non working for the
company. I have named this list as "leaves". I can not
get the formula right. Help would be appreciated. Thanks.

S

Use the NETWORKDAYS function.

=NETWORKDAYS(start_date,end_date, Leaves)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


<[email protected]> wrote in message
news:[email protected]...
> Hello All,
>
> How do I calculate how many working days between two
> dates. Using the UK holiday calender, I have a list of
> additional holiday dates that are non working for the
> company. I have named this list as "leaves". I can not
> get the formula right. Help would be appreciated. Thanks.
>
> S

Hi

Have a look at NETWORKDAYS(). I think you need to have the Analysis Toolpak
add-in loaded for this function.

--
Andy.


<[email protected]> wrote in message
news:[email protected]...
> Hello All,
>
> How do I calculate how many working days between two
> dates. Using the UK holiday calender, I have a list of
> additional holiday dates that are non working for the
> company. I have named this list as "leaves". I can not
> get the formula right. Help would be appreciated. Thanks.
>
> S

Thanks. This is great.

S

>-----Original Message-----
>Use the NETWORKDAYS function.
>
>=NETWORKDAYS(start_date,end_date, Leaves)
>
>
>--
>Cordially,
>Chip Pearson
>Microsoft MVP - Excel
>Pearson Software Consulting, LLC
>www.cpearson.com
>
>
><[email protected]> wrote in message
>news:[email protected]...
>> Hello All,
>>
>> How do I calculate how many working days between two
>> dates. Using the UK holiday calender, I have a list of
>> additional holiday dates that are non working for the
>> company. I have named this list as "leaves". I can not
>> get the formula right. Help would be appreciated.
Thanks.
>>
>> S
>
>
>.
>