Formula to compare two dates

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Hi

I am looking for a formula that compares two dates in a
worksheet. I have inserted the current date in cell L1
(using NOW()) and would like to compare this date with the
date in cell J88. When the date in L1 becomes older than
the date in J88, I would like the formula to return the
value EXPIRE in K88.

Does anyone know a formula that would solve this problem
for me?

Your help is greatly appreciated.
 
Hi

1. The function NOW() has a time component too - you better use TODAY()

2. No need for inserting TODAY() into cell - you can use it in your formula
directly. So enter into cell K88
=IF(TODAY()>J88,"EXPIRE","")


Arvi Laanemets
 
First I would recommend to use TODAY() instead of NOW() unless you also
look for a special time. Regardless a formula could look like

=IF(L1<J88,"EXPIRE","")

of course the formula has to be in K88
 
Thanks a lot Peo
Thomas
-----Original Message-----
First I would recommend to use TODAY() instead of NOW() unless you also
look for a special time. Regardless a formula could look like

=IF(L1<J88,"EXPIRE","")

of course the formula has to be in K88

--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top