Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | 1/1/2011 | 5 | ||
2 | 2/1/2011 | 4 | ||
3 | 3/1/2011 | 4 | ||
4 | 4/1/2011 | 5 | ||
5 | 5/1/2011 | 4 | ||
6 | 6/1/2011 | 4 | ||
7 | 7/1/2011 | 5 | ||
8 | 8/1/2011 | 4 | ||
9 | 9/1/2011 | 4 | ||
10 | 10/1/2011 | 5 | ||
11 | 11/1/2011 | 4 | ||
12 | 12/1/2011 | 4 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | =EOMONTH(TODAY(),-1)+1 | |
A2 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A3 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A4 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A5 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A6 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A7 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A8 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A9 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A10 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A11 | =EOMONTH(TODAY(),ROW()-2)+1 | |
A12 | =EOMONTH(TODAY(),ROW()-2)+1 | |
B1 | =IF(MONTH(A1)<>12,WEEKNUM(A2)-WEEKNUM(A1),52-WEEKNUM(A1)+1) | |
B2 | =IF(MONTH(A2)<>12,WEEKNUM(A3)-WEEKNUM(A2),52-WEEKNUM(A2)+1) | |
B3 | =IF(MONTH(A3)<>12,WEEKNUM(A4)-WEEKNUM(A3),52-WEEKNUM(A3)+1) | |
B4 | =IF(MONTH(A4)<>12,WEEKNUM(A5)-WEEKNUM(A4),52-WEEKNUM(A4)+1) | |
B5 | =IF(MONTH(A5)<>12,WEEKNUM(A6)-WEEKNUM(A5),52-WEEKNUM(A5)+1) | |
B6 | =IF(MONTH(A6)<>12,WEEKNUM(A7)-WEEKNUM(A6),52-WEEKNUM(A6)+1) | |
B7 | =IF(MONTH(A7)<>12,WEEKNUM(A8)-WEEKNUM(A7),52-WEEKNUM(A7)+1) | |
B8 | =IF(MONTH(A8)<>12,WEEKNUM(A9)-WEEKNUM(A8),52-WEEKNUM(A8)+1) | |
B9 | =IF(MONTH(A9)<>12,WEEKNUM(A10)-WEEKNUM(A9),52-WEEKNUM(A9)+1) | |
B10 | =IF(MONTH(A10)<>12,WEEKNUM(A11)-WEEKNUM(A10),52-WEEKNUM(A10)+1) | |
B11 | =IF(MONTH(A11)<>12,WEEKNUM(A12)-WEEKNUM(A11),52-WEEKNUM(A11)+1) | |
B12 | =IF(MONTH(A12)<>12,WEEKNUM(A13)-WEEKNUM(A12),52-WEEKNUM(A12)+1) |