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
|