Help with counting # of workdays

[CHARLESJOSEPH]

I did spend some time searching the forum but couldn't find an answer. This will be a piece of cake for all you Excel geniuses...

Have spreadsheet with the following columns:

Date Received - date a work item is received
Date Completed - date a work item is complete
Days To Complete - # of workdays taken to complete item
Days Outstanding - # of workdays item is outstanding as of today

For Days To Complete, if Date Received and Date Completed is populated, this should return the # of weekdays less holidays between Date Received and Date Completed; otherwise this should be blank.

For Days Outstanding, if Date Received is populated and Date Completed is not populated, this should return the # of weekdays less holidays between Date Received and Current Date; otherwise this should be blank.

 

[Andrew Poulsom]

Check out the NETWORKDAYS function in Excel Help. It's in the Analysis ToolPak Add-In, which must be installed.

 

[Jonmo1]

A2 = Date Recieved
B2 = Date Complete
$F$2:$F$10 = list of holiday dates (yes, you need to manually enter holiday dates)

Days to complete
=IF(OR(A2="",B2=""),"",NETWORKDAYS(A2,B2,$F$2:$F$10))

Days outstanding
=IF(AND(A2<>"",B2=""),NETWORKDAYS(A2,TODAY(),$F$2:$F$10),"")

These formulas require the Data Analysis Toolpack from Tools - Addins


Hope that helps.

 

[CHARLESJOSEPH]

You guys are so awesome! Thanks for the fantastic support!