Forum Discussion
How to calculate IRR for regular intervals but varying dates
Hi everyone, I am trying to create a formula to calculate the IRR for multiple properties each with a different start and end date. The properties are combined into one spreadsheet, each column repre...
Sorry I don't know what IRR is (to me it is inter-rater reliability) but read that it is some rate of return and presume you basically need a sum of value within that date range something like:
=SUMIFS($F2:$AC2, $F$1:$AC$1, ">" & $B2, $F$1:$AC$1, "<" & $C2, $F$1:$AC$1, "<" & TODAY() )
=SUMIFS($F2:$AC2, $F$1:$AC$1, ">" & $B2, $F$1:$AC$1, "<" & $C2, $F$1:$AC$1, "<" & TODAY() )
