formulas

  • Thread starter Thread starter mfg
  • Start date Start date
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?
 
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.
 
=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.
Click to expand...
 
sorry missed

this in g1 = (TODAY()-720>f1,( "do something"),("do Nothing"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
Excel Formula - Count Dates from another Sheet 8
how to calculate hrs flown in last one year 0
Add data from other sheet to the data present in this sheet 1
Excel Dragging countif formula with changing criteria 3
Formula help 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Help: Using CONCATENATE (and a COUNT?) for a total result 3

Back
Top