Make Workday count 6 days in a week

**BlastRanger** · 09-21-2010, 06:50 AM

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.

**zbor** · 09-21-2010, 07:22 AM

Is this correct result?

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

**BlastRanger** · 09-21-2010, 07:46 AM

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

**daddylonglegs** · 09-21-2010, 07:54 AM

Try this formula in C2 copied down

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

**zbor** · 09-21-2010, 08:33 AM

Or this:

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

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

**daddylonglegs** · 09-21-2010, 08:50 AM

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......

**BlastRanger** · 09-22-2010, 01:18 AM

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)