|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 17th, 2003, 12:19 AM
|
|||
|
|||
Date Function: How to determine number of Saturdays in a date range
I'm trying to create a sprdsht that will give me the
number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't been able to crack. Any ideas? 
|
|
#2
September 17th, 2003, 12:42 AM
|
|||
|
|||
|
Date Function: How to determine number of Saturdays in a date range
One possible way, with the start date in A1 and the end date in A2
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)={6,7})) -- Regards, Peo Sjoblom "Dan Picciotto" wrote in message ... I'm trying to create a sprdsht that will give me the number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't been able to crack. Any ideas?
|
|
#3
September 17th, 2003, 12:46 AM
|
|||
|
|||
|
Date Function: How to determine number of Saturdays in a date range
Hi Dan,
With your start date in A1, and end date in A2: =1+A2-A1-NETWORKDAYS(A1,A2) ' This one needs the Analysis ToolPak 'or =SUM(INT((A2-WEEKDAY(A2+{0;1})-A1+8)/7)) ' Without ATP Regards, Daniel M. "Dan Picciotto" wrote in message ... I'm trying to create a sprdsht that will give me the number of Saturdays and Sundays based on inputs of Starting Date and Ending Date. It's a nut i haven't been able to crack. Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
