| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
You got the concept.
-- Regards, Tom Ogilvy " 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
It should have been =NETWORKDAYS(C14+2,D14+2)
-- HTH Bob Phillips (remove xxx from email address if mailing direct) wrote in message oups.com... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
Bob,
Both gave the same result Thank Patrick |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
Thank both of you
I wish to help you one day Patrick |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Week starts on Saturday - Working days
Because 5 is 7-2 (7 days a week).
-- HTH Bob Phillips (remove xxx from email address if mailing direct) wrote in message oups.com... Bob, Both gave the same result Thank Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working Days of Week and DUE DATE for PAYMENT | Excel Worksheet Functions | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| 5 working days of a week | Excel Discussion (Misc queries) | |||
| how to change week-offs from saturday and sundays to sunday and mo | Excel Discussion (Misc queries) | |||
| Count working days by week | Excel Worksheet Functions | |||
Linear Mode
