I am attempting to create a date sensitive time table that looks like this:
Unfortunately I cannot include the cell A33 that contains 09/30/2006
I am trying to create a table that if I change the date in cell B3 the corresponding Column A dates will change according to the date in B3, which I have done...
The tricky part for me is that each calendar month has different end dates and I would like A formula that would cutt off at the end of each month thus not showing the next month if I drage the formula down... In other words I don't want to show this:
Is it possible to create a function that would carry out something like this:
If(Index(A31:A34)) is equal to 10/1/2006 then enter "" blank cell
Also if I entered a new cell in C3 and somehow would change cell B3 to the next month I could refer to this cell in the above attempted formula?
Any insight or help would be much appreciated!
Thanks in advance
Sean
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
3 | Date | Sep-06 | |||||
4 | 9/1/06 | ||||||
5 | 9/2/06 | ||||||
6 | 9/3/06 | ||||||
7 | 9/4/06 | ||||||
8 | 9/5/06 | ||||||
9 | 9/6/06 | ||||||
10 | 9/7/06 | ||||||
11 | 9/8/06 | ||||||
12 | 9/9/06 | ||||||
13 | 9/10/06 | ||||||
14 | 9/11/06 | ||||||
15 | 9/12/06 | ||||||
16 | 9/13/06 | ||||||
17 | 9/14/06 | ||||||
18 | 9/15/06 | ||||||
19 | 9/16/06 | ||||||
20 | 9/17/06 | ||||||
21 | 9/18/06 | ||||||
22 | 9/19/06 | ||||||
23 | 9/20/06 | ||||||
24 | 9/21/06 | ||||||
25 | 9/22/06 | ||||||
26 | 9/23/06 | ||||||
27 | 9/24/06 | ||||||
28 | 9/25/06 | ||||||
29 | 9/26/06 | ||||||
30 | 9/27/06 | ||||||
31 | 9/28/06 | ||||||
32 | 9/29/06 | ||||||
Sheet1 |
Unfortunately I cannot include the cell A33 that contains 09/30/2006
I am trying to create a table that if I change the date in cell B3 the corresponding Column A dates will change according to the date in B3, which I have done...
The tricky part for me is that each calendar month has different end dates and I would like A formula that would cutt off at the end of each month thus not showing the next month if I drage the formula down... In other words I don't want to show this:
Is it possible to create a function that would carry out something like this:
If(Index(A31:A34)) is equal to 10/1/2006 then enter "" blank cell
Also if I entered a new cell in C3 and somehow would change cell B3 to the next month I could refer to this cell in the above attempted formula?
Any insight or help would be much appreciated!
Thanks in advance
Sean