Count # days
 

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

=IF((NETWORKDAYS(A68,D68))=1,1,"")

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!

Count # days
 

If testing for same values why not use

=IF(A68=D68,"",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

http://nwexcelsolutions.com


"Annette" wrote in message
...
Here's my formula, but it is resulting unexpected.

=IF((NETWORKDAYS(A68,D68))=1,1,"")

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!

Count # days
 

Now ... why didn't I think of that (must be an age thing for me!). Yes,
that works
"Peo Sjoblom" wrote in message
...
If testing for same values why not use

=IF(A68=D68,"",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

http://nwexcelsolutions.com


"Annette" wrote in message
...
Here's my formula, but it is resulting unexpected.

=IF((NETWORKDAYS(A68,D68))=1,1,"")

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!