| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of sundays between two dates
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of sundays between two dates
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 "Carianne72" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of sundays between two dates
Hi!
Try this: A1 = start date B1 = end date =SUM(INT((WEEKDAY(A1-7,2)+B1-A1)/7)) Biff "Carianne72" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of sundays between two dates
Worked perfectly.
Thanks! "Peo Sjoblom" wrote: 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 "Carianne72" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of years/months/days between 2 dates | Excel Worksheet Functions | |||
| Retrieve multiple dates, from a week number? | New Users to Excel | |||
| How to find the number of days from 2 dates? | Excel Discussion (Misc queries) | |||
| calculate how many sundays between two dates in excel | Excel Discussion (Misc queries) | |||
| Find number of days between to dates | Excel Worksheet Functions | |||
Linear Mode
