Date formula to determine the number of days

[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!!!

 

[Teethless mama]

=Networkdays(Start_date,End_date,Holidays)

This formula is Required ATP add-in

 

[Gord Dibben]

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

 

[watermt]

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?

 

[Fred Smith]

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.