ryguy7272 wrote...
Change the range to suit your needs:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A29)),1)={1}))
....

OP would also need to change the {1} to 7 to count Saturdays rather
than Sundays.

But there's no need to use INDIRECT. Longer, but not volatile,

=INT((A29-A1)/7)+OR(WEEKDAY(A1,1)WEEKDAY(A29,1),WEEKDAY(A29,1)= 7)