I'm trying to break down a record into monthly day ranges...How would i do this.....
Turn this....
Account | Category | Date State | Date End | Budget |
123 | 454 | 1/15/2019 | 6/15/2019 | $6,000 |
Into this...(Minus total)
Account | Category | Month | No. Days | Total Number Days | Monthly Budget | Date State | Date End |
123 | 454 | January | 16 | 151 | 636 | 1/15/2019 | 6/15/2019 |
123 | 454 | February | 28 | 151 | 1113 | 1/15/2019 | 6/15/2019 |
123 | 454 | March | 31 | 151 | 1232 | 1/15/2019 | 6/15/2019 |
123 | 454 | April | 30 | 151 | 1192 | 1/15/2019 | 6/15/2019 |
123 | 454 | May | 31 | 151 | 1232 | 1/15/2019 | 6/15/2019 |
123 | 454 | June | 15 | 151 | 596 | 1/15/2019 | 6/15/2019 |
Total | 6000 |
Solved! Go to Solution.
Thank you! Exactly what i was looking for.