workdays

[Jimmy Joseph]

Hello,

How to return workdays by using a formula as mentioned below?

Networkdays function exclude weekend days... i would like to include
weekenddays (saturday) also.


Date workday

01.06.06 1
02.06.06 2
03.06.06 3
04.06.06
05.06.06 4
06.06.06 5
07.06.06 6
08.06.06 7
09.06.06 8
10.06.06 9
11.06.06
12.06.06 10
13.06.06 11
14.06.06 12
15.06.06 13
16.06.06 14
17.06.06 15
18.06.06
19.06.06 16

Regards,

Jimmy Joseph

 

[Ardus Petus]

Assuming 01.06.06 is in A2:

=IF(WEEKDAY(A2,2)=7,"",SUMPRODUCT(--(WEEKDAY(A$2:A2,2)<7)))
and drag down

HTH

 

[Bob Phillips]

Jimmy,

If you want to just move the weekend, so that Sat is a workday, but Mon is a
weekend day, then use

=NETWORKDAYS(A1-1,A2-1)

If you want to have a 6 day week with Sat, use

=NETWORKDAYS(A1,A2)+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=7))

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)