How to count working days as a processing time

[sc77]

I am trying to calculate the number of working days between two dates. However, I only want the calculation to perform if there is an entry in date one otherwise the cell should remain blank.

Example; number of working days between G6 and H6. Calculation only performed if G6 has a valid date entry (is populated).

In addition to this, how could I then exclude public holidays from the calculation as I understand there is a holidays table that has to be written but I just get an error response.

Thanks!

 

[VoG]

Try like this where K1:K20 contains a list of holiday dates

=IF(G6="","",NETWORKDAYS(G6,H6,K1:K20))

 

[sc77]

Thanks VoG; the formula works but I have a question on the calculation..

I assume Excel considers saturday and sunday as non-working days but what about another calendar such as middle east where friday and saturday are holidays?

Thanks!

 

[barry houdini]

If you have Excel 2010 you can use NETWORKDAYS.INTL function instead of NETWORKDAYS - that allows you to specify the weekend days

In earlier versions of Excel you can adjust NETWORKDAYS to give you different weekend days as long as the weekend is still 2 consecutive days, e.g. for Fri/Sat weekend change to

=IF(G6="","",NETWORKDAYS(G6+1,H6+1,INDEX(K1:K20+1,0)))

If you want a Thu/Fri weekend then the +1s become +2s etc.