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