conditional formatting or formulae to show elapsed dates
 

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.

conditional formatting or formulae to show elapsed dates
 

Assuming date in B2 try the following:
=IF((B2-TODAY()<0),"Expired", "OK")

"Jo" wrote:

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.

conditional formatting or formulae to show elapsed dates
 

Brilliant! Thanks JC

"JC" wrote:

Assuming date in B2 try the following:
=IF((B2-TODAY()<0),"Expired", "OK")

"Jo" wrote:

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.

conditional formatting or formulae to show elapsed dates
 

=IF(TODAY()B2,"Expired","OK")


"Jo" wrote:

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.