Month End Balancing
 

Hey guys, new to the excel game, knowledge is limited. I need to do a
spreadsheet that will recognize day count. Basically a clinet purchases a
security that accrues intrest on a 28 day basis. For reporting purposes if
the issue is purchased on the 15th of the month the month end balance for
intrest earned is 15 days, with the following 13 days carrying foward how can
I build taht logic into the spreadsheet ?