Calculate Business Days instead of Calendar Days

[davygryan]

Is there a formula I could use to calculate Business Days instead of calender Days.

We are currently using a cycle time in Calendar Days but we need to change it to Business Days which obviously causes some problems when weekends come into play.

 

[gsistek]

Using the WORKDAY formula should work.

 

[davygryan]

Using the WORKDAY formula should work.

If I have a start and an end date does this formula calculate the workdays in between excluding the weekends

 

[barry houdini]

No, for that you need NETWORKDAYS function. In Excel 2003 and earlier NETWORKDAYS is an Analysis ToolPak function - you need to enable that to use it.

In Excel 2007 and later versions NETWORKDAYS is a "built-in" function

=NETWORKDAYS(A2,B2)

optionally you can also exclude holidays from the count

=NETWORKDAYS(A2,B2,holidays)

 

[davygryan]

No, for that you need NETWORKDAYS function. In Excel 2003 and earlier NETWORKDAYS is an Analysis ToolPak function - you need to enable that to use it.

In Excel 2007 and later versions NETWORKDAYS is a "built-in" function

=NETWORKDAYS(A2,B2)

optionally you can also exclude holidays from the count

=NETWORKDAYS(A2,B2,holidays)

Cool thanks a million