View Single Post
 
Old 04-14-2016, 08:35 AM
LynnMac2016 LynnMac2016 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Mar 2016
Posts: 30
LynnMac2016 is on a distinguished road
Default NETWORKDAYS Question

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 :-)
Reply With Quote