Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NEED FORMULA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NEED FORMULA
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
NEED FORMULA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|