I want to calculate Sundays between a specific date & today ()
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
"Mike" wrote in message
...
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
"Zahid Khan" wrote:
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
|