# Week starts on Saturday - Working days

P

#### 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.

G

#### 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.

P

#### 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
try with start date March 18 and end date March 29
Regards,
Patrick

P

#### 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
try with start date March 18 and end date March 29
Regards,
Patrick

G

#### Guest

You got the concept.

B

#### Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

P

#### plhermine

Bob,

Both gave the same result

Thank Patrick

P

#### plhermine

Thank both of you

Patrick

B

#### Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)