# 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.  Register To Reply

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

Is this correct result?

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

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

Hi, to be simple,  Register To Reply

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))))  Register To Reply

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.  Register To Reply

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......  Register To Reply

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

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)  Register To Reply