View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Week starts on Saturday - Working days

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



" 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