JaberwokieinAlice
New member
- Joined
- Aug 20, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
[FONT="]I am looking for the formula that does the following spread / distribution between a start date and an end date: if the start date is mid month it calculates 14/31, etc, then between the start and end months inserts the value 1 and for the final month identifies the value of the end date 10/31. e.g. refer to the table below.The values not equal to 1 are to be rounded up. The months reflected in the columns are the end of the month e.g. 31 Oct or 30 Nov, etc
[/FONT]
[/FONT]
Net Programme | Oct-19 | Nov-19 | Dec-19 | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | ||
Start Date | End Date | 2019 | 2020 | ||||||||||||||
Q 4 | Q 1 | Q 2 | Q 3 | Q 4 | |||||||||||||
Overall Project | |||||||||||||||||
Contract Award -> Practical Completion | 14/10/2019 | 10/12/2020 | 0.5 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 |