View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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