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


"jcheko" wrote:

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

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


On Tue, 4 Mar 2008 16:45:00 -0800, jcheko
wrote:

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

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?


"Teethless mama" wrote:

=Networkdays(Start_date,End_date,Holidays)

This formula is Required ATP add-in


"jcheko" wrote:

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

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.

"watermt" wrote in message
...
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?


"Teethless mama" wrote:

=Networkdays(Start_date,End_date,Holidays)

This formula is Required ATP add-in


"jcheko" wrote:

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