I want to calculate Sundays between a specific date & today ()
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 |
I want to calculate Sundays between a specific date & today ()
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 |
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com