Hello,
I need to be able to create a formula in the DAY cells below that tally the number of MONDAYs, TUESDAYs, and WEDNESDAYs within the Searchable Cells according to the Date Range specified. I have attempted "=SUM(N(WEEKDAY(F4:F536)=2))" to start but I cannot figure out how to get it to focus its search between date ranges.
Searchable Cells Date Range
A
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Thank you for any assistance you can provide
I need to be able to create a formula in the DAY cells below that tally the number of MONDAYs, TUESDAYs, and WEDNESDAYs within the Searchable Cells according to the Date Range specified. I have attempted "=SUM(N(WEEKDAY(F4:F536)=2))" to start but I cannot figure out how to get it to focus its search between date ranges.
Searchable Cells Date Range
A
04/01/2014 |
04/14/2014 |
05/01/2014 |
05/27/2014 |
06/05/2014 |
07/01/2014 |
08/16/201 |
09/01/2014 |
<tbody>
</tbody>
05/15/2014 | 07/16/2014 |
<tbody>
</tbody>
Monday | Value |
Tuesday | Value |
Wednesday | Value |
Thursday | Value |
Friday | Value |
Saturday | Value |
Sunday | Value |
<tbody>
</tbody>
Thank you for any assistance you can provide