Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Mondays in Date Range
I want to count the number of Mondays etc. in a date range. I found the
following on Chip Pearson's site... =SUM(IF(WEEKDAY(A2-1+ROW(INDIRECT("1:"&TRUNC(B2-A2)+1)))=C2,1,0)) Where A2 is the start date, B2 is the end and C2 is the weekday number Whilst this does the trick I would prefer a solution which is not an array formula. Can this be done another way e.g. with Sumproduct or similar and if so how please? Thanks a lot Kewa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Within a Date Range | Excel Worksheet Functions | |||
Counting a range to see if it encompasses a given date | Excel Worksheet Functions | |||
Counting Unique Values by Date Range | Excel Worksheet Functions | |||
Counting if between date range | Excel Worksheet Functions | |||
Counting values within a Date Range | Excel Discussion (Misc queries) |