Count Workdays in Excel 2010

philb99

Active Member
Joined
Feb 3, 2014
Messages
404
Office Version
  1. 2010
Platform
  1. Windows
Hi Lookingfor some help please

I have a tab in a separate sheet linking to the Master Sheet.Four columns in sheet Col A. Date Started Col B. Date Complete Col C. Did itmeet <90 days Col D. Link to column C (Yes, No but if date equals 00/01/1900then NUM!) Col E. Start of Month – 01/10/2018 (this reports cases up until30/09/2018

What I would like, if the dates in Col B = #NUM! then create in Col F the totalnumber of work days for those cases only,
from when they had started.

Thanks
 
Last edited:

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Is the #NUM! caused by an error?

Try the below, i'm not sure how many days you want to measure up to from the start date so have added TODAY() as the to date.

=IF(ISERR(B2)=TRUE,NETWORKDAYS(A2,TODAY()),"")
 
Upvote 0
Thanks for helping - As I am linking to another spreadsheet the #NUM ! shows because there is no Completed date in the Master Sheet.

I only want to add those with No Completion date which are the ones recoded as #NUM !

I want to count Networkdays from Started Date to 1 October 2018 and then each month will change 01 October to 01 November etc
 
Upvote 0
Thanks again - Ah I can see that that the formulae is based on #NUM ! Can it be based on the default date 00/01/1900 at all please. Otherwise perfect
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top