ExcelBanter - calculate how many sundays between two dates in excel

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

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

- - calculate how many sundays between two dates in excel (https://www.excelbanter.com/excel-discussion-misc-queries/45338-calculate-how-many-sundays-between-two-dates-excel.html)

jeff thinkin

calculate how many sundays between two dates in excel

calculate how many times sundays occurs between two dates in excel

Bernd Plumhoff

Hi Jeff,

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

array-entered

HTH,
Bernd

All times are GMT +1. The time now is 04:44 AM.