View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bperks bperks is offline
external usenet poster
 
Posts: 1
Default Date Calculation Problem

I am trying to figure out how to take a date (01/01/05) in A1, and
months in A2 (the months could vary from 12 all the way up to 60)and
have A3 show me the actual date format of 01/01/05 + 60 months =
01/01/10 or whatever it would be due to the leap years and all. Needs
to be triggered by input from A2. Thanks in advance for any help!!!!


Effective Date (A1) 01/01/05
Term in Months (A2) 60
Expiration Date (A3) ________


************
bperks
Excel 2002
USA
************