calculation sundays between two dates

J

jeff thinkin

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)
 
P

Paul Sheppard

jeff said:
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)
Click to expand...

Hi jeff

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

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

Niek Otten

You had several answers already to your previous post

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
R

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)
Click to expand...


Try:

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