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
RE: Week starts on Saturday - Working days
You will need to adjust the NETWORKDAYS formula. It can be done without too
much problem as long as you are willing to forget the holidays (or subtract
them later). The rationale: the only weeks that can change the total number
will be the start and end weeks. For all the "middle" weeks you will work 5
of the 7 days, so the total will be the same. But you need to adjust the
number based on what day the time period starts and/or ends on. For example,
if it starts on Saturday, NETWORKDAYS will subtract the first 2 days from its
total, but you need to include them. So you need to take account for which
day the time period starts on and which day it ends on. If I did the logic
correctly here is the formula (assuming start date in A1 and end date in A2):
- K Dales
> 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
Re: Week starts on Saturday - Working days
thank a lot everybody. I have enough information to play with my
workdays time sheet.
Thank a lot again for your help. Much appreciated.
It doesn't need to be that complicated. If your start date is in A1 and end date in B1 just use
If you have a range of holidays you wish to exclude use
This one needs to be confirmed with CTRL+SHIFT+ENTER
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1