Given a start date and end date, I'm trying to calculate the time diff. in number of Months, BUT representing the count of the Months per each year. For example:
Start Date: 01/25/2020
End Date: 06/28/2023
Occurrences in 2020 only: formula I have: timediff (in months) between Start Date and 12/31/2020
Occurrences in 2021 only: need formula here (I cannot hard code the value of 12)
Occurrences in 2022 only: need formula here (I cannot hard code the value of 12)
Occurrences in 2023 only: formula I have: timediff (in months) between 01/01/2023 and End Date
Thank you!
Start Date: 01/25/2020
End Date: 06/28/2023
Occurrences in 2020 only: formula I have: timediff (in months) between Start Date and 12/31/2020
Occurrences in 2021 only: need formula here (I cannot hard code the value of 12)
Occurrences in 2022 only: need formula here (I cannot hard code the value of 12)
Occurrences in 2023 only: formula I have: timediff (in months) between 01/01/2023 and End Date
Thank you!