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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Edward - 27 Sep 2007 13:52 GMT

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!

Reply to this Message

Pranav Vaidya - 27 Sep 2007 14:06 GMT

Hi Edward,

change your formula as
=IF(A9="","",NETWORKDAYS(A1, A9))

Signature

Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!

> Hi, I have a section of a worksheet that just needs to show working days
> between two dates.
[quoted text clipped - 6 lines]
>
> Thanks!

Reply to this Message

David Biddulph - 27 Sep 2007 15:03 GMT

=IF(COUNT(A1,A9)=2,NETWORKDAYS(A1, A9),"")

Signature

David Biddulph

> Hi, I have a section of a worksheet that just needs to show working days
> between two dates.
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message