Number of sundays between two dates

C

Carianne72

I need to calculate the number of Sundays between two dates in Excel. I have
looked at the NETWORKDAYS function, but it omits weekends. So, any
suggestions are appreciated.
 
P

Peo Sjoblom

Put the start date in A1, the end date in A2, then you can use

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=7))


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
 
B

Biff

Hi!

Try this:

A1 = start date
B1 = end date

=SUM(INT((WEEKDAY(A1-7,2)+B1-A1)/7))

Biff
 
R

Ron Rosenfeld

I need to calculate the number of Sundays between two dates in Excel. I have
looked at the NETWORKDAYS function, but it omits weekends. So, any
suggestions are appreciated.
Click to expand...

Try this, from Daniel M.

A1: start date
A2: end date

=INT((A2-WEEKDAY(A2)-A1+8)/7)


--ron
 
Top