Date Computation

S

sylink

I need a macro to determine dates using 6-month frequency. To
illustrate, I have these dates:

Given:
Input Date = 12-Feb-2008
Maturity Date = 20-Dec-2011

Required:
Last Coupon Date = ?
Next Coupon Date =?

Manual Computation
Last Coupon Date(6-month freq) = 20-Dec-2007 (Must have same day and
month as the matuirty date above.e.g20-Dec;and year nearest to input
date e.g 2007)

Next Coupon Date = 20-May-2008 (6 months from last coupon
date;date-20th must remain unchanged)
 
U

UglyChicken

I need a macro to determine dates using 6-month frequency. To
illustrate, I have these dates:

Given:
Input Date = 12-Feb-2008
Maturity Date = 20-Dec-2011

Required:
Last Coupon Date = ?
Next Coupon Date =?

Manual Computation
Last Coupon Date(6-month freq) = 20-Dec-2007 (Must have same day and
month as the matuirty date above.e.g20-Dec;and year nearest to input
date e.g 2007)

Next Coupon Date = 20-May-2008 (6 months from last coupon
date;date-20th must remain unchanged)

Where cell A1 holds the date:
=DATE(YEAR(A1),MONTH(A1)+6,DAY(20))
(untested)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top