ExcelBanter - Count Weekend Days solutions thank you very much to both of you

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count Weekend Days solutions thank you very much to both of you (https://www.excelbanter.com/excel-worksheet-functions/169022-count-weekend-days-solutions-thank-you-very-much-both-you.html)

koob

Count Weekend Days solutions thank you very much to both of you

Domenic

Count Weekend Days solutions thank you very much to both of you

To count the number of Saturdays and Sundays...

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

....where A2 contains the start date, and B2 contains the end date.

Hope this helps!

In article ,
koob wrote:

All times are GMT +1. The time now is 12:55 AM.