Here are some formula for advancing dates

1 day =DATE(YEAR(B9),MONTH(B9),DAY(B9)+1)
1 month =DATE(YEAR(B10),MONTH(B10)+1,DAY(B10))
1 year =DATE(YEAR(B11)+1,MONTH(B11),DAY(B11))

Just change the +n to your requirements.

Regards.

Bill Ridgeway
Computer Solutions

"JAAN2000" wrote in message
...
i do research and need to create a appointment list for up to two years.

what formula would figure out from date of enrollment appointments that
Are
in one week, then the next in 2 weeks, then one month , then 3 months then
6
months,9 months etc. JAAN