Forum Discussion
Number of months per year between 2 dates
Community ChampionWhat is the logic here? Where do 5, 12, 6 come from?
The logic and the goal is to make a distribution of the load per month, the loads are filled per year.
(I just realized a mistake in the column year ... sorry ... bad copy/paste)
ID------Year----Start date--------End date--------Annual Load--------Result(my wish)
150----2018----18/08/2018-------30/06/2020----100------------------5
150----2019----18/08/2018-------30/06/2020----50-------------------12
150--- 2020----18/08/2018-------30/06/2020----120------------------6
5 months: Since the 18/08/2018 to 31/12/2018
12, 6 ...
- HotChilli
Still not clear...
ID------Year----Start date--------End date--------Annual Load--------Result(my wish)
150----2018----18/08/2018-------30/06/2020----100------------------5
150----2019----18/08/2018-------30/06/2020----50-------------------12
150--- 2020----18/08/2018-------30/06/2020----120------------------65 months: Since the 18/08/2018 to 31/12/2018<----------------------- why 31/12/2018
12, 6 ... <------------- please explain these
These 3 lines are for the same project:
ID------Year----Start date--------End date--------Annual Load--------Result(my wish)
150----2018----18/08/2018-------30/06/2020----100------------------5- The start date for the project is 18/08/2018 and the end 30/06/2020. The project manager filled a load of 100 days for 2018. I want to make a distribution of this load for the month for 2018. That means 100/5 => 20 days for, August 2018, September 2018, November 2018 and December 2018.
150----2019----18/08/2018-------30/06/2020----50-------------------12
- For this example the load must be distributed on the year of 2019 because 01/01/2019 - 31/12/2019 is inside of the start and end date, so 50/12 = 4,17 days
150--- 2020----18/08/2018-------30/06/2020----120------------------6
- Same thing but only on 6 months because the end date.
I hope it's clear now :-)