Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Specific Day within Dates
Hi,
Is there a way to find how many Day (eg. wednesdays) within a a date range? Like how many Wednesdays (any given Day) falling between June 1, 2009 Till June 21, 2009 Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Specific Day within Dates
On Mon, 29 Jun 2009 03:44:01 -0700 (PDT), Abdul
wrote: Hi, Is there a way to find how many Day (eg. wednesdays) within a a date range? Like how many Wednesdays (any given Day) falling between June 1, 2009 Till June 21, 2009 Thanks, Put the first date in cell A1, the last date in cell A2 and the code for the weekday, i.e. 4 for Wednesday, in cell A3. The try the following formula: =SUMPRODUCT(- -(WEEKDAY(A1-1+ROW(INDIRECT("A1:A"&(A2-A1+1))))=A3)) Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of Specific Day within Dates | Excel Worksheet Functions | |||
Number of Specific Day within Dates | Excel Worksheet Functions | |||
Number of Specific Day within Dates | Excel Worksheet Functions | |||
Number of Specific Day within Dates | Excel Worksheet Functions | |||
Number of Specific Day within Dates | Excel Worksheet Functions |