CT Witter
MrExcel MVP
- Joined
- Jul 7, 2002
- Messages
- 1,212
I have a budget table based on our own fiscal calendar. Below is the table layout.
What I want to do is query and have what the total would be for a given date range. For example 1/1/05-1/24/05 should total 1,356,495.94. This is based on 1/1-1/19 total of 1,114,804.05 . There are then 35 days for the second period so each day is worth 60,422.97. So 60,422.97 * 4 days is 241,691.89.
How would I do this?
Thanks,
CT
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | StartDate | EndDate | Type | TotalCost | ||
| 2 | 01-Jan-05 | 19-Jan-05 | 1 | $1,114,804.05 | ||
| 3 | 20-Jan-05 | 24-Feb-05 | 1 | $2,114,804.05 | ||
| 4 | ||||||
| 5 | 1/1-1/19 | $1,114,804.05 | ||||
| 6 | 1/20/-1/24 | $241,691.89 | ||||
| 7 | Total | $1,356,495.94 | ||||
Sheet1 | ||||||
What I want to do is query and have what the total would be for a given date range. For example 1/1/05-1/24/05 should total 1,356,495.94. This is based on 1/1-1/19 total of 1,114,804.05 . There are then 35 days for the second period so each day is worth 60,422.97. So 60,422.97 * 4 days is 241,691.89.
How would I do this?
Thanks,
CT
