# Make Workday count 6 days in a week

1. ## Make Workday count 6 days in a week

Hi,
In my company, working day is monday to saturday.
How to count for example :
Today is 21 September 2010.
My task will expired 20 workdays after today. So if I use =workday() the result is incorrect because excel count workday from monday to friday only.

Is there any chance to change the excel =workday() and =networkdays() to count 6 days in a week as a workday.

2. ## Re: Make Workday count 6 days in a week

Is this correct result?

=A1+20+IF(WEEKDAY(A1,2)=1,2,3)

3. ## Re: Make Workday count 6 days in a week

Hi, to be simple,
please fill my attached spreadsheet with formula (there are explaination about what I want)

4. ## Re: Make Workday count 6 days in a week

Try this formula in C2 copied down

=A2-WEEKDAY(A2,3)+INT(7/6*(B2+MIN(5,WEEKDAY(A2,3))))

5. ## Re: Make Workday count 6 days in a week

Or this:

=A2+B2+(WEEKDAY(A2;2)<7)+INT(B2/7)

Edit: I think your example in C3 is wrong date.

6. ## Re: Make Workday count 6 days in a week

Originally Posted by zbor
=A2+B2+(WEEKDAY(A2;2)<7)+INT(B2/7)
I don't think that works, zbor.

Simple example: A2 = today = Tuesday 21st Sept 2010, B2 = 1......formula should return the next working day, i.e. Wednesday 22nd Sept....but that formula returns the Thursday......

7. ## Re: Make Workday count 6 days in a week

Hi daddy,
Thankyou, your formula work correctly.
May I ask why the formula is
=A2-WEEKDAY(A2,3)+INT(7/6*(B2+MIN(5,WEEKDAY(A2,3))))

The weekday is ,3 to count 0-6 monday-sunday, why not count from ,2 1-7 monday-sunday.
also could you please explain the INT(7/6*(B2+MIN(5,WEEKDAY(A2,3)

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1