Count Workdays in Excel 2010

[philb99]

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

 

[mrshl9898]

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()),"")

 

[philb99]

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

 

[mrshl9898]

So =IF(ISERR(B2)=TRUE,NETWORKDAYS(A2,E2),"") ?

 

[philb99]

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

 

[mrshl9898]

The default date is numerically 0.

So:

=IF(B2=0,NETWORKDAYS(A2,E2),"")

 

[philb99]

Perfect -thanks for all of your help on this.