I guess that you mean that you want to do some sort of math with the changed
days.

If it is just to calculate working days, use

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)),1) ={1,2,3,4,5}))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Mohammed" wrote in message
...
Dear all,
i would like to change the Sunday as non-working day to be working day and
change the friday to be non-working day.
Can you help me pls??
Best regards