software

Here's my formula, but it is resulting unexpected.

=IF((NETWORKDAYS(A68,D68))=1,1,quot;quot;)

I want to eliminate 'same day'. So if the date is 1/1/06 in A68 and 1/1/06
in D68, I don't want a number but rather a blank. My formula indicates 1
when it sees same day.

The formula works correctly if cell A has 1/1/06 and cell d has 1/2/06 = 1

Thanks!
If testing for same values why not use

=IF(A68=D68,quot;quot;,your _formula

if you use the same dates and the dates are on a weekend date networkdays
will return zero
whereas it is on a weekday it will return 1--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Annettequot; gt; wrote in message
...
gt; Here's my formula, but it is resulting unexpected.
gt;
gt; =IF((NETWORKDAYS(A68,D68))=1,1,quot;quot;)
gt;
gt; I want to eliminate 'same day'. So if the date is 1/1/06 in A68 and
gt; 1/1/06 in D68, I don't want a number but rather a blank. My formula
gt; indicates 1 when it sees same day.
gt;
gt; The formula works correctly if cell A has 1/1/06 and cell d has 1/2/06 = 1
gt;
gt; Thanks!
gt;
Now ... why didn't I think of that (must be an age thing for me!). Yes,
that works
quot;Peo Sjoblomquot; gt; wrote in message
...
gt; If testing for same values why not use
gt;
gt; =IF(A68=D68,quot;quot;,your _formula
gt;
gt; if you use the same dates and the dates are on a weekend date networkdays
gt; will return zero
gt; whereas it is on a weekday it will return 1
gt;
gt;
gt;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Annettequot; gt; wrote in message
gt; ...
gt;gt; Here's my formula, but it is resulting unexpected.
gt;gt;
gt;gt; =IF((NETWORKDAYS(A68,D68))=1,1,quot;quot;)
gt;gt;
gt;gt; I want to eliminate 'same day'. So if the date is 1/1/06 in A68 and
gt;gt; 1/1/06 in D68, I don't want a number but rather a blank. My formula
gt;gt; indicates 1 when it sees same day.
gt;gt;
gt;gt; The formula works correctly if cell A has 1/1/06 and cell d has 1/2/06 =
gt;gt; 1
gt;gt;
gt;gt; Thanks!
gt;gt;
gt;
gt;