TheJonWithNoH
New Member
- Joined
- Sep 8, 2017
- Messages
- 30
Good Evening,
In one "master sheet" in cell "A1" I have the date 1/1/2020. This cell / date controls many other formulas in my workbook. In cell "B2" of another sheet I have a formula that equals cell "A1" in my master sheet. I need cells "B3" and below to proceed with 1/2/2020, 1/3/2020, etc but once the month is over I need it to start back at 1/1/2020 and repeat 4 times. After every day in the month has repeated 4 times I need the next month to start.
Also, in this same sheet in column A i have 4 values that I need to repeat every day. I have these values listed in cells AB2:AB5. I also have a list of months in cells AC2:AC13 and formula to count the number of days in these months in AD2:AC13. Here's an example:
<tbody>
</tbody>
I'm not to great at explaining these but hopefully someone will understand and be able to help me out.
Thanks in advance!
JB
In one "master sheet" in cell "A1" I have the date 1/1/2020. This cell / date controls many other formulas in my workbook. In cell "B2" of another sheet I have a formula that equals cell "A1" in my master sheet. I need cells "B3" and below to proceed with 1/2/2020, 1/3/2020, etc but once the month is over I need it to start back at 1/1/2020 and repeat 4 times. After every day in the month has repeated 4 times I need the next month to start.
Also, in this same sheet in column A i have 4 values that I need to repeat every day. I have these values listed in cells AB2:AB5. I also have a list of months in cells AC2:AC13 and formula to count the number of days in these months in AD2:AC13. Here's an example:
A | B |
Apples | 1/1/2020 |
Apples | 1/2/2020 |
Apples | 1/3/2020 |
Apples | 1/4/2020 |
Apples | 1/5/2020 |
...... | ....... All the way down to the end of the month |
Apples | 1/31/2020 |
Oranges | 1/1/2020 |
Oranges | 1/2/2020 |
Oranges | 1/3/2020 |
..... | ..... All the way down to the end of the month |
Oranges | 1/31/2020 |
Bananas | 1/1/2020 |
...... | .... All the way down to the end of the month |
Bananas | 1/31/2020 |
Apples | 2/1/2020 (start over with apples for new month) |
Apples | 2/2/2020 |
<tbody>
</tbody>
I'm not to great at explaining these but hopefully someone will understand and be able to help me out.
Thanks in advance!
JB