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

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

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

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

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