calculation sundays between two dates

cell A1 has start date (eg) 12/08/05
cell A2 has end date (eg) 25/08/05

and cell A3 has the formular that displays a the number of sundays occured
(in this example the result is 2)

You had several answers already to your previous post

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"jeff thinkin" <[email protected]> wrote in message
news:[email protected]...
> cell A1 has start date (eg) 12/08/05
> cell A2 has end date (eg) 25/08/05
>
> and cell A3 has the formular that displays a the number of sundays occured
> (in this example the result is 2)

On Wed, 14 Sep 2005 08:52:06 -0700, jeff thinkin
<[email protected]> wrote:

>cell A1 has start date (eg) 12/08/05
>cell A2 has end date (eg) 25/08/05
>
>and cell A3 has the formular that displays a the number of sundays occured
>(in this example the result is 2)


Try:

=INT((A2-WEEKDAY(A2)-A1+8)/7)
--ron