NETWORKDAYS Question

[LynnMac2016]

Hi

I have the NETWORKDAYS function working perfectly to show number of work days between 2 dates minus holidays. However, I want to go one step further and keep getting loads of error messages so I'm hoping someone on the Forum can offer some assistance.



The end date may not always be completed as it depends on a date a document is received by me, so I'm typing the word "Pending" in that end date cell until I have an actual date the document is received.

It obviously shows #VALUE! until a date is entered. Can the formula be tweaked so that if the word "Pending" is entered in the end date cell, it will return a value of 0, rather than #VALUE!?

Any advice greatly appreciated.

Lynn :-)

[xor]

With start_date in A1 and end_date in A2:

=IFERROR(NETWORKDAYS(A1,A2),0) or
=IF(ISTEXT(A2),0,NETWORKDAYS(A1,A2))

[LynnMac2016]

Thank you for this