Number of sundays between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change weekends from Sat, Sun to Fri, Sat in networkdays 3
Networkdays plus Sundays 8
Determining the Sunday date of the third "full" weekend of a month 25
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1
Formula to tell day of week 2
Need number of Saturdays and number of Sundays between 2 dates 1
Networkdays including Saturday? 5

Back
Top