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,

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