Thread: formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default 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