M
mfg
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?
todays date. How do I increment the date +720 days?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JMay
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))
M
mfg
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.
years old or more then in g1 notify me to do something or else do notheing.
S
stew
=today()+720
mfg said: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.
S
stew
sorry missed
this in g1 = (TODAY()-720>f1,( "do something"),("do Nothing"))
this in g1 = (TODAY()-720>f1,( "do something"),("do Nothing"))