Formula to compare two dates

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.
 
A

Arvi Laanemets

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
 
P

Peo Sjoblom

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
 
T

Thomas

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





.
 

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

Top