NETWORKDAYS Fx

**chrisbob28** · 05-20-2013, 02:40 PM

Hi. This should be relatively simple but I have a spreadsheet that I wish to calculate the number of days between two dates excluding the weekends and then subtracting 1 day so as to not include the first 24 hours. In any case, I can calculate this data just fine but I want the spreadsheet to not display an error, a false statement or a #value statement if no data is entered. Here is the formula I am using:

=NETWORKDAYS(D2,G2)-DAY(1)

I have tried various IF(AND) and IF(OR) combos but to no avail. Can anyone give me a simple suggestion for this? Thanks in advance.

Chris

**Pepe Le Mokko** · 05-20-2013, 02:44 PM

Maybe

Please Login or Register  to view this content.

**chrisbob28** · 05-20-2013, 02:47 PM

Originally Posted by Pepe Le Mokko

Maybe

Please Login or Register  to view this content.

Thank you! That works, however it gives me a negative 1 value since it's then essentially subtracting 1 from 0 since no data is entered. Is there a way I can hide the -29577 or the -1 if nothing is entered. Thanks again! Maybe I just need to not include negative numbers in my formatting?

**Pepe Le Mokko** · 05-20-2013, 02:56 PM

Like this ?

Please Login or Register  to view this content.

BTW don't quote entire posts unnecessarily, it clutters the thread - Thx

**chrisbob28** · 05-20-2013, 03:03 PM

Thank you for your help Pepe and thank you for solving my issue!

Chros

**daddylonglegs** · 05-20-2013, 03:18 PM

Originally Posted by Pepe Le Mokko

=IF(OR(ISERROR(NETWORKDAYS(D2,G2)-1),(NETWORKDAYS(D2,G2)-1)<0),"",(NETWORKDAYS(D2,G2)-1))

ISERROR won't work as part on an OR function, that formula will still return an error if D2 is a text value, for example. I suggest using

=IFERROR(MAX(0,NETWORKDAYS(D2,G2)-1),"")