Date subtraction -How to not show negative when 2nd date not entered

E

Edward

Hi, I have a section of a worksheet that just needs to show working days
between two dates.
For example, an order was entered on 9/2/07 and complete on 9/15/07

The formula =NETWORKDAYS(A1, A9) works perfectly except that until the
"completed date" ise filled in, a negative number appears.

Is there a way to have that remain blank until both dates have been entered?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Field Subtraction 3
Leaving a formula cell blank when data has not yet been added. 5
Negative Dates and/or Times 3
how can I get a cell to change color by date to indicate expiery t 1
To show month end date from any date entered 7
Date not being automatically entered 3
Excel If (or similar) 6
Dates linked in Excel files 3

Top