I need a way to determine how much of a given period (start and end dates held in separate columns) falls within a financial year (1/1/XXXX - 31/12/XXXX). Can anyone help me to determine the number of months in that period that falls in the financial year.
I found a similar question to determine the number of days - is there a way to convert this to months? Start Date in A2 and End Date in B2 =MAX(0,MIN($B2,DATE(2019,12,31))-MAX($A2,DATE(2019,1,1))+1)
Really appreciate the help!