Week starts on Saturday - Working days

[plhermine]

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

 

[Guest]

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.

 

[plhermine]

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

 

[plhermine]

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

 

[Guest]

You got the concept.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[plhermine]

Bob,

Both gave the same result

Thank Patrick

 

[plhermine]

Thank both of you

I wish to help you one day

Patrick

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)