Total Payment monthly breakdown based on Start and End Date Columns
I need some support with a formula, if anyone can help me 😁
I have the below sheet where I have created costing for resource use between a Start and End Date Column supported by a total day column count between the two dates and use a day rate column to multiply the total column.
What I would like now to do, is create 12 columns for each month to break down the total over the months covered by the start date.
Start Date: 15/01/2023
End Date: 5/02/2023
Day Rate: £100
I would like to break that down further to
January: 16 Days x £100 = £1600 (Column Value)
February: 5 Days x £100 = £500 (Column Value)
Any Help would be much appreciated? If you need any further info please let me know.
Help Article Resources
Check out the Formula Handbook template!