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" <jeffthinkin@discussions.microsoft.com> wrote in message
news:10E9B0F1-4653-429E-A1BE-8114C3F18C43@microsoft.com...
> 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
<jeffthinkin@discussions.microsoft.com> 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