I want to calculate Sundays between a specific date & today ()

[Guest]

Respected Sir
I want to calculate Sundays between a earlier specific date & today ()
Plz gide me about the Function releted wit above work.

thank you
Zahid Khan

 

[Guest]

Try this:-
=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=1,1,0))


Start date in A1, End date in A2.

This is an array formula so enter it with CTRL+Shift+Enter.

Will that do?

Mike

 

[T. Valko]

Good (array entered):

=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(TODAY()-A1)+1)))=1,1,0))

Better (normally entered):
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&TODAY())),2)=n))

Best (normally entered):
=INT((WEEKDAY(A1-n,2)+TODAY()-A1)/7)

Where n = day of week: Monday = 1 ...... Sunday = 7

Biff