Date formula to determine the number of days

  • Thread starter Thread starter jcheko
  • Start date Start date
J

jcheko

can anyone helpme...figure out a formula that counts the "bussiness days"
excluding weekends and holidays?....is anything like this available in
excel?...thanks in advance

ps
US calendar of course!!!
 
=Networkdays(Start_date,End_date,Holidays)

This formula is Required ATP add-in
 
Check out the NETWORKDAYS function available in the Analysis ToolPak add-in

=networkdays(date1, date2) will return total working days less weekends.

Also has provision for holidays.

=networkdays(date1, date2, holidays_range)

See help for explanations and example formulas.


Gord Dibben MS Excel MVP
 
I am trying to use =Networkdays(Start_date,End_date,Holidays) in one of my
Excel 2003 spreadsheets and keep getting the #NAME? error. I do have the
Analysis ToolPak checked. I can get the =Networkdays(Start_date,End_date)
formula to work but would also like to use the Holiday feature of this
formula, can you possibly help with this?
 
You need to define the Holidays range. That's what Excel is complaining
about. Alternatively, just use the range directly, as in:
=Networkdays(a1,a2,a3:a10)

Regards,
Fred.
 
Back
Top