How many days

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi

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

=NETWORKDAYS(start_date,end_date, Leaves)


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