Here is a good formula for calculating the 7.5yr Date based on the DOLA date.
in my case my DOLA date is stored in cell (O3) just replace the three O3's with the cell that your date is stored in:
=DATE(YEAR(O3)+7,MONTH(O3)+6,DAY(O3))
if you only want to calculate 7yrs just remove the +6
Hope this is helpful!
Message Edited by nosxih on 04-26-2008 10:43 PM
