A very simple way:

Add number of days to your enrollment date:

Date + 7 .... One week ahead
Date + 14 ....2 weeks
Date+91 .... 3 months (approx)
Date+182 .... 6 months

OR

this will add 3 calendar months to the date (given as TODAY in the example)

=DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))

one year to current date:

=DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY()))

HTH

"JAAN2000" wrote:

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