charlesstricklin
Board Regular
- Joined
- May 6, 2013
- Messages
- 98
- Office Version
- 2021
- Platform
- Windows
I don't know if this is even possible but you guys have pulled off the incredible before so I thought I'd ask,
Imagine I have a sheet where a start and end date of each week worked are in columns A & B, two different companies in columns C & D, and a sum of each row of data in column E.
I'd like to be able to separate data by month. Since both column A & B include a date range that frequently goes over between the end of a month and the beginning, is that going to make it impossible to split?
Imagine I have a sheet where a start and end date of each week worked are in columns A & B, two different companies in columns C & D, and a sum of each row of data in column E.
I'd like to be able to separate data by month. Since both column A & B include a date range that frequently goes over between the end of a month and the beginning, is that going to make it impossible to split?
Income.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Start | End | Company A | Company B | Total | ||
2 | March 11, 2024 | March 18, 2024 | $ 170.00 | $ 124.00 | $ 294.00 | ||
3 | March 4, 2024 | March 11, 2024 | $ 183.00 | $ 83.00 | $ 266.00 | ||
4 | February 26, 2024 | March 4, 2024 | $ 212.00 | $ 70.00 | $ 282.00 | ||
5 | February 19, 2024 | February 26, 2024 | $ 213.00 | $ 88.00 | $ 301.00 | ||
6 | February 12, 2024 | February 19, 2024 | $ 162.00 | $ 160.00 | $ 322.00 | ||
7 | February 5, 2024 | February 12, 2024 | $ 64.00 | $ 118.00 | $ 182.00 | ||
8 | January 29, 2024 | February 5, 2024 | $ 161.00 | $ 159.00 | $ 320.00 | ||
9 | January 22, 2024 | January 29, 2024 | $ 163.00 | $ 228.00 | $ 391.00 | ||
10 | January 15, 2024 | January 22, 2024 | $ 75.00 | $ 138.00 | $ 213.00 | ||
11 | January 8, 2024 | January 15, 2024 | $ 88.00 | $ 208.00 | $ 296.00 | ||
12 | January 1, 2024 | January 8, 2024 | $ 65.00 | $ 149.00 | $ 214.00 | ||
13 | December 25, 2023 | January 1, 2024 | $ 193.00 | $ 194.00 | $ 387.00 | ||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E13 | E2 | =SUM(C2:D2) |