Another one;
=INT((WEEKDAY(A1-*1*)+B1-A1)/7)
Note: There are 2 opening brackets before WEEKDAY.
A1 = Start_Date
B1 = End_Date
*1* = Sun, *2* = Mon, *3* = Tue, *4* = Wed, *5* = Thu, *6* = Fri, *7* = Sat
If you want to count multiple days between 2 dates use then inside an Array
separated by co
Thank you! Worked like a charm!
On Oct 10, 1:27 pm, RockyFontane wrote:
> I am trying to count the number of Sunday's between two date ranges.
> For example, Start Date: 9/25/2011; End Date: 10/24/2011. The
> number of Sunday's between these two dates are 5. What's the best way
> to write th
