Build in Formula to count Weekend between 2 dates

[Faridwahidi]

Hi,

Besides using workaround DAYS() - NETWORKDAYS(),

Is there any build-in function to count weekend days between 2 dates.

[FDibbins]

Possible with using sumproduct and weekday()?

[Faridwahidi]

Hi FDibbins,

WEEDAY() will return 1 to 7 (Sunday to Saturday). It is really nonsense to count number of days in weekend between 2 dates.

[mattsmith]

Try:

Please Login or Register  to view this content.

where B2 is your start date and C2 is your end date. The "1111100" part indicates which days to include/exclude, i.e. 1 = exclude, 0 = include.

[Tony Valko]

Here are 2 ways...

A1 = start date
B1 = end date

To count the Saturday and Sunday dates within the date range of A1:B1...

=SUM(INT((WEEKDAY(A1-{6,7},2)+B1-A1)/7))

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)>=6))

[Faridwahidi]

Hi mattsmith,

Thanks a lot. welcome to forum

@ Tony,

Tq for another alternative method.

[Tony Valko]

You're welcome!