Spreadsheet: 711436d1609708553-figure-out-an-exact-expenditure-date-based-on-monthly-costs-sample-2
Sheet: Sheet1

 | Total Cost | Funded Amount | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | Date for 50% | Date for 100% |  |  |  |  |  | Workdays |  | Holidays |  | 100% Expended | For Date at 100% | Money out | % of mth | Days out | Date for 100%
ACCOUNT 1 |  | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 | 20 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 | 20 | 2020-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 | 20 | 2020-03-01 00:00:00
 |  | Monthly | 0 | 110 | 120 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  |  | 2020-06-01 00:00:00 | 20 | 2020-04-01 00:00:00 |  |  |  | n6-1000
 |  | Total Cumulative |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 | 20 | 2020-05-01 00:00:00
 | Total Cost | Funded Amount |  |  |  |  |  |  |  |  |  |  |  |  | Date for 50% | Date for 100% |  |  |  |  |  | 2020-03-01 00:00:00 | 20 | 2020-06-01 00:00:00
ACCOUNT 2 |  | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 | 20 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 | 20 | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 | 20 | 2020-09-01 00:00:00
 |  | Monthly | 0 | 200 | 120 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  |  | 2020-07-01 00:00:00 | 20 | 2020-10-01 00:00:00
 |  | Total Cumulative |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | 20 | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00 | 20 | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00 | 20 | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | 20 | 2021-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00 | 20 | 2021-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | 20
 |  | New to this forum, so hoping I am providing enough context, and appreciate any help! We have accounts in which we track financial expenditures on, and have the cost broken out by month. We are required to provide XX days advance notice to the client of being 100% expended down to the business day. Currently, we have it set up with formulas to only pull the specific dates we are going to be 100% expended on (have not even gotten to the point yet of building in the XX days advance notice), and I am sure there is a better way to do this but this the way it's always been done, so was hoping to get pointed in the right direction of making it more efficient.
 |  | Overview of the current set up: formula (col P) finds the month where the 100% expenditure occurs in the table. Col Q is formula that pulls the last day in the month where 100% expenditure occurs. Columns T & U connect to P & Q, and counts backwards from the end of month by using the number of workdays to the right (V & W), not including our own company holidays (Z). To make matters more complicated, we have to manually adjust R & S by moving them to the month where the 100% expenditure occurs in order to correctly populate the other formulas.