Number of sundays between two dates
On Mon, 7 Aug 2006 18:37:01 -0700, Carianne72
wrote:
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.
Try this, from Daniel M.
A1: start date
A2: end date
=INT((A2-WEEKDAY(A2)-A1+8)/7)
--ron
|