View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sylink[_3_] sylink[_3_] is offline
external usenet poster
 
Posts: 17
Default Date Computation

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)