Hi,
I have been having some problems with the NETWORKDAYS formula, regarding same dates and weekends. That is not my question however.
To get round my NETWORKDAYS formula issues, I am using this formula:
=IF(ISNUMBER($H3),IF(OR(COUNTIF(Weekends,H3),NETWORKDAYS($G3,$H3),(NETWORKDAYS(G3,H3)-1)),""))
This appears to work, except my result cell is blank, even when H3 is populated. My previous formula did this, although the NETWORKDAYS result was inconsistent:
=IF(ISNUMBER($K4),(NETWORKDAYS($J4,$K4,Weekends)-1),"")
I am sure I am missing something simple, but I am stumped. If anyone has any ideas on my networkdays issue also, you are very welcome.
Thanks
David
I have been having some problems with the NETWORKDAYS formula, regarding same dates and weekends. That is not my question however.
To get round my NETWORKDAYS formula issues, I am using this formula:
=IF(ISNUMBER($H3),IF(OR(COUNTIF(Weekends,H3),NETWORKDAYS($G3,$H3),(NETWORKDAYS(G3,H3)-1)),""))
This appears to work, except my result cell is blank, even when H3 is populated. My previous formula did this, although the NETWORKDAYS result was inconsistent:
=IF(ISNUMBER($K4),(NETWORKDAYS($J4,$K4,Weekends)-1),"")
I am sure I am missing something simple, but I am stumped. If anyone has any ideas on my networkdays issue also, you are very welcome.
Thanks
David