networkday - datedif
 

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

--
Message posted via http://www.officekb.com

networkday - datedif
 

One way:

=NETWORKDAYS(A1, B1) - 1


In article <825feba2f62fa@uwe, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

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

networkday - datedif
 

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

"BNT1 via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

networkday - datedif
 

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)



In article ,
JE McGimpsey wrote:

One way:

=NETWORKDAYS(A1, B1) - 1


In article <825feba2f62fa@uwe, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

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

networkday - datedif
 

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

"BNT1 via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com

networkday - datedif
 

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

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

Hi

[quoted text clipped - 10 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200804/1