calculate how many sundays between two dates in excel

jeff thinkin · Sep 14, 2005

calculate how many times sundays occurs between two dates in excel

Bernd Plumhoff · Sep 14, 2005

Hi Jeff,

=SUM(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1))

array-entered

HTH,
Bernd