Thread
:
Calculate the number of Saturdays or Sundays between 2 dates?
View Single Post
#
2
Biff
Posts: n/a
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!
Reply With Quote