Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
I am trying to write a formula for a date. The formula will add 2 years to
todays date. How do I increment the date +720 days? -- mfg41 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))
"mfg" wrote: I am trying to write a formula for a date. The formula will add 2 years to todays date. How do I increment the date +720 days? -- mfg41 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
The formula I am trying to write is as follows. If the date in cell f1 is 2
years old or more then in g1 notify me to do something or else do notheing. -- mfg41 "JMay" wrote: =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) "mfg" wrote: I am trying to write a formula for a date. The formula will add 2 years to todays date. How do I increment the date +720 days? -- mfg41 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
=today()+720
"mfg" wrote: The formula I am trying to write is as follows. If the date in cell f1 is 2 years old or more then in g1 notify me to do something or else do notheing. -- mfg41 "JMay" wrote: =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) "mfg" wrote: I am trying to write a formula for a date. The formula will add 2 years to todays date. How do I increment the date +720 days? -- mfg41 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas
sorry missed
this in g1 = (TODAY()-720f1,( "do something"),("do Nothing")) "mfg" wrote: The formula I am trying to write is as follows. If the date in cell f1 is 2 years old or more then in g1 notify me to do something or else do notheing. -- mfg41 "JMay" wrote: =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) "mfg" wrote: I am trying to write a formula for a date. The formula will add 2 years to todays date. How do I increment the date +720 days? -- mfg41 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |