NETWORKDAYS including Saturdays

[hasrijadi]

NETWORKDAYS including Saturdays - T. Valko
29-Aug-07 02:29:59

Try this:

A2 = start date
B2 = end date
C2:C10 = list of holiday dates

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)<7),--(ISNA(MATCH(ROW(INDIRECT(A2&":"&B2)),C2:C10,0))))

--
Biff
Microsoft Excel MVP

===============================================

how to make C2:C10 not counting.

coz if copy from this formula C2:C10 wiil counting to C3:C11 and so on.

I want this formula static with C2:C10. (not counting)



Best Regards

============

Hasri

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[T. Valko]

how to make C2:C10 not counting.

I want this formula static with C2:C10. (not counting)

Those 2 statements seem to conflict.

If you DO NOT want to count any holidays and just count the weekdays Monday
through Saturday:

A2 = start date
B2 = end date

=SUM(INT((WEEKDAY(A2-{1,2,3,4,5,6},2)+B2-A2)/7))

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)<7))