Hi Guys - So I have a huge file which mentions the total expense for the year. I want to break down the expense into months (so ideally I'd want to have one column for January, one for February and so on with the expense for that month being mentioned in that column).
In my data set I've calculated the start date of the expense and the end date of the expense (it could be starting in the middle of the year and ending in the middle of the year as well). What's the best way to do create a monthly schedule? I assume there would be a multi field formula i can use which will automatically do this for me. See below an example from the data set
Data
| Total Expense | Expense From | Expense Till | Total Days for expense |
| 1,000 | 15 March 2019 | 15 Nov 2019 | 245 |
Output:
| Total Exp | Expense From | Expense Till | Total Days for expense | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
| 1,000 | 15 March 2019 | 15 Nov 2019 | 245 | 0 | 0 | 65.30612 | 122.449 | 126.5306 | 122.449 | 126.5306 | 126.5306 | 122.449 | 126.5306 | 61.22449 | 0 | 1,000 |
Thanks
