Days in the month
Hi,
Am Fri, 6 Feb 2015 09:29:23 +0000 schrieb Quilp:
Bridging Loan
4 02/06/2014 28/02/2015 249 £0.00 £110.22 £110.22 £6.56 £0.55 Yes £0.04 £1.12 0
Bridging Loan
4 02/06/2014 28/02/2015 249 £0.00 £110.22 £110.22 £6.56 £0.55 Yes £0.04 £1.01 0
then try:
=IF(N4=0,IF(TODAY()-B4<DAY(EOMONTH(TODAY(),0)),(TODAY()-B4)*G4*0.0328767%,G4*0.0328767%*DAY(EOMONTH(TODAY( ),0))),0)*(M4<=TODAY())
If the result is not correct, please send me a file with data and the
expected output
claus_busch(at)t-online.de
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|