Counting working days

[peteh]

Could someone please advise how I get the following formula to count working days using the networkdays function

=IF(BK66<>"",BK66-AE66,"")

BK66 is a date that an action is completed and AE66 is the date it started.

Many thanks

 

[rsulliva]

Try this:

=IF(BK66<>"",networkdays(AE66,BK66),"")

You have to have enabled the Analysis Toolpack in Excel for this function to work.

 

[T. Valko]

Try this:

=IF(BK66<>"",networkdays(AE66,BK66),"")

You have to have enabled the Analysis Toolpack in Excel for this function to work.

The NETWORKDAYS function needs to have the Analysis ToolPak add-in installed for Excel versions 2003 and earlier.

In Excel versions 2007 and later the functions from the Analysis ToolPak add-in are now native, built-in functions.