Need help with calculating the number of months that occur within a particular year for each project. To make it easier for anyone entering information, I only have them enter the Start Year and the Start Month. It then needs to calculate out for each year, i.e: 2020, 21, 22, etc. I can get it to easily calculate for the current year but not sure how to get it to calculate only for a later year. So far my efforts also produce errors for 2021. Project A should be 6 months and Project B 5 months for 2021.
As time progresses, we will need to copy the last column and add on the following year to keep track.
I included the 12/31 and 1/1 dates at the top of the columns to try and help me figure this out but I've had no luck and not sure if they are needed.
Tried using XL2BB but it wouldn't paste correctly so I created a table to hopefully help. I can upload the file if needed and allowed.
Thank you!
As time progresses, we will need to copy the last column and add on the following year to keep track.
I included the 12/31 and 1/1 dates at the top of the columns to try and help me figure this out but I've had no luck and not sure if they are needed.
Tried using XL2BB but it wouldn't paste correctly so I created a table to hopefully help. I can upload the file if needed and allowed.
12/31/2020 | 12/31/2021 | 12/31/2023 | 12/31/2023 | ||||||
1/1/2019 | 1/1/2021 | 1/1/2023 | 1/1/2023 | ||||||
duration (months) | start year | start month | start date | end date | 2020 | 2021 | 2022 | 2023 | |
Project A | 12 | 2020 | 6 | 6/1/2020 | 6/1/2021 | 6 | 5 | ||
Project B | 9 | 2020 | 8 | 8/1/2020 | 5/1/2021 | 4 | 4 | ||
Project C | 11 | 2021 | 3 | 3/1/2021 | 2/1/2022 | ||||
Project D | 21 | 2021 | 7 | 7/1/2021 | 4/1/2023 |
Thank you!