Hello, can anyone help me with excel formula for the column Month before year start, Duration (months), Month after year end and Months in 21/22 below please :-
FY 21/22 | Year Start: 01/08/2021 | Year End: 01/08/2022 | ||||
Project | Project Dates Start | Month before year start | Project Dates End | Duration (months) | Month after year end | Months in 21/22 |
1 | 01/05/2021 | 30/04/2025 | ||||
2 | 01/12/2020 | 30/11/2021 | ||||
3 | 01/09/2020 | 31/08/2023 | ||||
4 | 01/01/2021 | 31/12/2021 | ||||
5 | 01/10/2021 | 30/09/2025 |