networkday - datedif

[BNT1 via OfficeKB.com]

Hi

In Cell A1 i have 4/4/08
In cell B1 i have 4/4/08

I have tried networkdays(a1,b1) but this gives result as 1. I require result
as 0. when cell B1 reads 5/4/08, will require result 1
Datedif does give the required result, but does not exclude weekends

any ideas/direction

all help appriciated

Brian

 

[JE McGimpsey]

One way:

=NETWORKDAYS(A1, B1) - 1

 

[Dennis]

=IF(B1=A1,0,NETWORKDAYS(A1,B1))

 

[JE McGimpsey]

Disregard - I misread your dates.

Your example seems a bit ambiguous - you want to "exclude weekends", but
if a weekend date is entered (e.g., 5/4/08), you want it to count?

Perhaps

=NETWORKDAYS(A1,B1)-(WEEKDAY(B1,2)<6)

 

[Dennis]

1 is correct as it represents the 1 day of the 4/4/08

 

[BNT1 via OfficeKB.com]

Sorry to confuse you all, I chose an example date that was a friday :-(
Unfortunately, I do not have the tool pac is not installed at home , ,
networkdays(a1,b1)-1 looks good. I was trying networkdays(a1,(b1-1)) which
gave a minus number

Thank you to all for your speedy response

Regards

Brian

1 is correct as it represents the 1 day of the 4/4/08

Hi

[quoted text clipped - 10 lines]

Brian