Formulas

  • Thread starter Thread starter Lee Wroth
  • Start date Start date
L

Lee Wroth

I am trying to creat a field within a speadsheet that
calculates working days only, between any 2 given dates.
Can this be done, and if so, how do I write the formula?

e.g. Column one has date 01.03.2003 column two has dates
10.05.2003. Column three would then calculate the number
of working days (not including weekends or Bank Holidays).

Lee
 
=NETWORKDAYS(A1,B1,L1:L6)

where L1:L6 contains the list of Bank Holidays. You must
list the actual dates, not the names of the holidays
(like "Christmas").

HTH
Jason
Atlanta, GA
 
Look in help for NETWORKDAYS

you can create your own list with holidays like

=NETWORKDAYS(start_date,end_date,holidays)

note that it is part of the add-in ATP which comes with Excel
but if you get a name error it has to be installed
 
Hi Lee!

Take a look at the NETWORKDAYS Function. It's an Analysis ToolPak one
and you may need to use Tools > Addins > Check "Analysis ToolPak".

=NETWORKDAYS(A1,B1,Holidays)

Returns the number of days between A1 and B1 excluding weekends and
public holidays in the form of dates in a range named Holidays.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top