Post Reply 
Simple Interest
05-17-2015, 04:40 PM (This post was last modified: 05-17-2015 04:52 PM by salvomic.)
Post: #2
RE: Simple Interest
...a first formula per financial year could be:

30*(mm2-mm1)+dd2-dd1

is from 13 May 2015 to 21 November 2015 there are 192 actual days (DDAYS(2015.0513, 2015.1121)), but only 188 "financial" days: 30*(11-5)+21-13

This formula *should* works independently of leap year...

to be continued...

∫aL√0mic (IT9CLU) :: HP Prime 50g 41CX 71b 42s 39s 35s 12C 15C - DM42, DM41X - WP34s Prime Soft. Lib
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Simple Interest - salvomic - 05-17-2015, 03:10 PM
RE: Simple Interest - salvomic - 05-17-2015 04:40 PM
RE: Simple Interest - salvomic - 05-17-2015, 07:48 PM
RE: Simple Interest - salvomic - 05-18-2015, 01:59 PM



User(s) browsing this thread: 1 Guest(s)