How many days

[Guest]

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

 

[Guest]

Hi

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

 

[Chip Pearson]

Use the NETWORKDAYS function.

=NETWORKDAYS(start_date,end_date, Leaves)


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

 

[Guest]

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





.