Anyone have a formula that will calculate the number of Saturdays or Sundays between 2 dates? Thanx!
J Jim Long Nov 1, 2005 #1 Anyone have a formula that will calculate the number of Saturdays or Sundays between 2 dates? Thanx!
B Biff Nov 1, 2005 #2 Hi! One way: A1 = start date A2 = end date =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)>5)) Biff
Hi! One way: A1 = start date A2 = end date =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)>5)) Biff
