calculate how many sundays between two dates in excel

[jeff thinkin]

a formular to give the number of times sundays occurs between a starting date
and a finishing date...

 

[Niek Otten]

http://www.cpearson.com/excel/DateTimeWS.htm

Somewhat beneath the middle of the page

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Don Guillett]

try this
=SUMPRODUCT((D222>=E1)*(D222<E2)*(WEEKDAY(D222)=1))