How do I show a purchase every 5 years after the initial purchase of an
asset. For instance, I have an individual, age 40, who wants to buy an auto
at the age of 42 and then buy one every 5 years. I can get the first year of
purchase but not the subsequent purchase every 5 years to build a table.
i.e.
Data field:
Current age of person 40
Cost of auto $20,000
Start date from now (in years) 2
Replacement of auto (in years) 5

Table: Purchase
Age of auto
40 $0
41 $0
42 $20,000
43 $0
44 $0
45
initial formula: =IF(age=$current age$+$start date from now$,use cost,0)

I appreciate the help.
Thank you