I have rejigged a Table I previously used to Spread an Amount equally over a 12 Month Period. This was for ££££. I am now trying to repurpose this to be able to spread a set number of expected work days (1-330) across a set period of months (1-18) See example
The issue I am having is that there is a maximum amount of Working Days per month but I am not sure how to include that (so the days shown are not more than the available days)
Is it possible? The end goal beyond this is to create a formula whereby by entering the number of available days and a start and end date; the formula will spread through the months columns equally between the 2 dates (without exceeding the max available days)
example - If i have 150 Days Allocated for A project I want to be able to spread that out through an equal period of months (not exceeding the total amount of working days for each month - that bit could be simplified to be a standard max of 20 days)
but i think you have achieved that in your example....
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.