HI guys
i been given a spreadsheet at work and there is a formula that i dont understand
the formula is =IF(DATEVALUE(E$1)-TRIM(A2)>=0,B2,IF(DATEVALUE(E$1)-TRIM(C2)>0,DATEDIF(C2,E$1+30,"m")*D2,0))
the data s below
<tbody>
1
A
B
C
D
E
2
end date
price
start date
per month
30/06/2016
3...