A | B | C | D | |
1 | DOJ | Amount | End Date | Result |
2 | 43967 | 2000 | 44286 | =B2*12*YEARFRAC(A2,C2,3) |
3 | 44243 | 2000 | 44286 | =B3*12*YEARFRAC(A3,C3,3) |
A | B | C | D | |
1 | DOJ | Amount | End Date | Result |
2 | 5/16/2020 | 2000 | 3/31/2021 | 20975.34 |
3 | 2/16/2021 | 2000 | 3/31/2021 | 2827.40 |
DOJ | Amount | Result | Total year value | Result | formula |
16-05-20 | 2000 | 21032 | 24000 | 20975.34 | IF($A2<DATE(2020,4,1),(D2),(D2)/365*(DATE(2021,3,31)-$A2)) |
16-02-21 | 2000 | 2928 | 24000 | 2827.397 | IF($A2<DATE(2020,4,1),(D2),(D2)/365*(DATE(2021,3,31)-$A2)) |