• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding the frequency of a day between two dates

M

murugaraj

New Member
Hi,

I would like to find the number of Sundays in between two dates. Is there a way?

Thanks in advance for your help.


Murugaraj
 
Try This

=INT(((A2-((WEEKDAY(A2)<>1)*WEEKDAY(A2)))-A1)/7)+1

A1: Start date

A2: End date
 
You must log in or register to reply here.
Back
Top