calculation sundays between two dates

[Guest]

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)

 

[Paul Sheppard]

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)

Hi jeff

Try this >
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A14&":"&B14)))=1))

Where the red 1 indicates a Sunday, 2 would be Monday etc

 

[Niek Otten]

You had several answers already to your previous post

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Ron Rosenfeld]

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