NEED FORMULA

[JAAN2000]

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

 

[Toppers]

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

 

[Bill Ridgeway]

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