ExcelBanter - Calculate the number of Saturdays or Sundays between 2 dates?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculate the number of Saturdays or Sundays between 2 dates? (https://www.excelbanter.com/excel-discussion-misc-queries/53126-calculate-number-saturdays-sundays-between-2-dates.html)

Jim Long

Calculate the number of Saturdays or Sundays between 2 dates?

Anyone have a formula that will calculate the number of Saturdays or Sundays
between 2 dates? Thanx!

Biff

Calculate the number of Saturdays or Sundays between 2 dates?

Hi!

One way:

A1 = start date
A2 = end date

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

Biff

"Jim Long" <Jim wrote in message
...
Anyone have a formula that will calculate the number of Saturdays or
Sundays
between 2 dates? Thanx!

All times are GMT +1. The time now is 07:17 AM.