Week starts on Saturday - Working days

Does anyone have a function, or know where I could get one
for this problem?

My week starts on Saturday and finish on Wednesday. My week-end is
Thursday and Friday.

I want to calculate the working days but NETWORKINGDAYS consider Sunday
or Monday as first day of the week.

Thank in advance for your help

If you are not using holidays

=NetWorkdays(StartDate-2,EndDate-2)

If you are using holidays, then adjust the dates of the holidays to match.


--
Regards,
Tom Ogilvy



"[email protected]" wrote:

> Does anyone have a function, or know where I could get one
> for this problem?
>
> My week starts on Saturday and finish on Wednesday. My week-end is
> Thursday and Friday.
>
> I want to calculate the working days but NETWORKINGDAYS consider Sunday
> or Monday as first day of the week.
>
> Thank in advance for your help
>
>

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

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

You got the concept.

--
Regards,
Tom Ogilvy


"[email protected]" wrote:

> 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

Thank both of you

I wish to help you one day

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
>