View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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