Week starts on Saturday - Working days

hello Tom,

Thanks a lot. If I quote your formula I receive 3 working days but if I
quote your modified formila such as : =NETWORKDAYS(C14-5,D14-5) I
received a good result.
try with start date March 18 and end date March 29
Regards,
Patrick

It should have been =NETWORKDAYS(C14+2,D14+2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> hello Tom,
>
> Thanks a lot. If I quote your formula I receive 3 working days but if I
> quote your modified formila such as : =NETWORKDAYS(C14-5,D14-5) I
> received a good result.
> try with start date March 18 and end date March 29
> Regards,
> Patrick
>

Bob,

Both gave the same result

Thank Patrick

Because 5 is 7-2 (7 days a week).

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> Bob,
>
> Both gave the same result
>
> Thank Patrick
>