The maturity date is an entirely different calculation from how much interest a CD accrues. The interest formula's don't require exact dates to calculate the interest; "0.5" works just fine for "six months"
I finally found a function that does the trick for the dates. From: "J.C. O'Connell"
Also, I think some of them compound daily so you need to calculate a daily interest rate and figure your total interest based on that. ----------------- J.C.O'Connell [email protected] ----------------- -----Original Message----- From: PDML [mailto:[email protected]] On Behalf Of J.C. O'Connell Sent: Saturday, October 13, 2012 7:40 PM To: 'Pentax-Discuss Mail List' Subject: RE: Why won't the internet just answer the stupid, question? remember six months is 182.5 days so calculating maturity date isnt so simple. thats why I said I wouldnt be surprised if its actually a 180 days term.
-- PDML Pentax-Discuss Mail List [email protected] http://pdml.net/mailman/listinfo/pdml_pdml.net to UNSUBSCRIBE from the PDML, please visit the link directly above and follow the directions.

