I have a series of dates from 2000 to 2013 (am using 2000 as an example) and I calculated the day that each of these date ranges began and ended. The Dur stands for the Duration (inclusive) of the two dates.
Excel 2010
<tbody>
</tbody>
<tbody>
</tbody>
My objective is to count the number of days in each month as well as the number of days of the week that the years date ranges add up to. This is where the formulas will be sorted, the month figures for the first two years have been computed manually (but I would really like a formula to do this). The day figures are simply approximations.
Excel 2010
<tbody>
</tbody>
<tbody>
</tbody>
Excel 2010
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
2 | 2000 | Start | End | Dur | Start D | End D |
3 | 11-Apr | 15-Apr | 5 | Tue | Sat | |
4 | 28-Apr | 10-May | 13 | Fri | Wed | |
5 | 23-May | 31-May | 9 | Tue | Wed | |
6 | 9-Jun | 18-Jun | 10 | Fri | Sun | |
7 | 30-Jun | 6-Jul | 7 | Fri | Thu | |
8 | 13-Jul | 20-Jul | 8 | Thu | Thu | |
9 | 3-Aug | 9-Aug | 7 | Thu | Wed | |
10 | 18-Aug | 23-Aug | 6 | Fri | Wed | |
11 | 1-Sep | 10-Sep | 10 | Fri | Sun | |
12 | 18-Sep | 24-Sep | 7 | Mon | Sun |
<tbody>
</tbody>
Homestands
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>
My objective is to count the number of days in each month as well as the number of days of the week that the years date ranges add up to. This is where the formulas will be sorted, the month figures for the first two years have been computed manually (but I would really like a formula to do this). The day figures are simply approximations.
Excel 2010
H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|
1 | Y/M | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |
2 | 2000 | 8 | 18 | 10 | 14 | 13 | 18 | 2 | |
3 | 2001 | 16 | 14 | 16 | 10 | 13 | 12 | 3 | |
4 | 2002 | 12 | 12 | 3 | |||||
5 | 2003 | ||||||||
6 | 2004 | ||||||||
7 | 2005 | ||||||||
8 | 2006 | ||||||||
9 | 2007 | ||||||||
10 | 2008 | ||||||||
11 | 2009 | ||||||||
12 | 2010 | ||||||||
13 | 2011 | ||||||||
14 | 2012 | ||||||||
15 | 2013 |
<tbody>
</tbody>
Homestands
Excel 2010R | S | T | U | V | W | X | Y | |
---|---|---|---|---|---|---|---|---|
1 | Y/D | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
2 | 2000 | 13 | 10 | 8 | 12 | 13 | 13 | 13 |
3 | 2001 | |||||||
4 | 2002 | |||||||
5 | 2003 | |||||||
6 | 2004 | |||||||
7 | 2005 | |||||||
8 | 2006 | |||||||
9 | 2007 | |||||||
10 | 2008 | |||||||
11 | 2009 | |||||||
12 | 2010 | |||||||
13 | 2011 | |||||||
14 | 2012 | |||||||
15 | 2013 |
<tbody>
</tbody>
Homestands
Does anyone know what I can do to make these calculations to determine the number of Mondays (or any days) within 2000 within these ranges or the number of days in August within these ranges for example. Anyone who could help me on this one would be really appreciated. Thanks in advance.