calculate how many sundays between two dates in excel
 

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

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

Somewhat beneath the middle of the page

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"jeff thinkin" <jeff wrote in message
...
a formular to give the number of times sundays occurs between a starting
date
and a finishing date...

try this
=SUMPRODUCT((D2:D22=E1)*(D2:D22<E2)*(WEEKDAY(D2:D 22)=1))

--
Don Guillett
SalesAid Software

"jeff thinkin" <jeff wrote in message
...
a formular to give the number of times sundays occurs between a starting
date
and a finishing date...