Hello I am looking at calculating interest depending if the month and date are within the range of a term deposit.
My formula appears to work for the current year in question but not for the following year. Formulae is as follows thanks.
=IF(TEXT(R$4,"mmyyyy")>TEXT($G5,"mmyyyy"),0,IF(TEXT(R$4,"mmyyyy")=TEXT($G5,"mmyyyy"),$D5*$E5*SUM(($G5-$J$4)/365),$D5*$E5*SUM((R$4-Q$4)/365)))
My formula appears to work for the current year in question but not for the following year. Formulae is as follows thanks.
=IF(TEXT(R$4,"mmyyyy")>TEXT($G5,"mmyyyy"),0,IF(TEXT(R$4,"mmyyyy")=TEXT($G5,"mmyyyy"),$D5*$E5*SUM(($G5-$J$4)/365),$D5*$E5*SUM((R$4-Q$4)/365)))