I am using the DATEDIF formula & it is not considtent with the calculations. I am using it to calculate the amount of months passed, to calculate accruals & the following happens:
where I17 is the end date of last invoice & F2 is the current end of the month (i.e. this month is 30/11/2020)
I have attached an image where you can see the calculation is wrong. Can someone please help explain why when the end date is Oct 2020 that in the month of Nov 2020, the accrual value is not 1?
This formula works fine for an accrual which ended June 2020 (correctly calculated 5 months)