Complicated Formula to Distinguish, weather the License is Valid o

[Khalid A. Al-Otaibi]

I am working on a Huge Date requested by the Management, but I stopped
working due to the data requested is hard to finalized it. It really need a
Genius to create a formulas; It’s more than one formulas, but I am sure that
you can create it. You’re much better than me, and thank you in advance;

Let’s say for Example;

.. A B C
D

1 Mr. MMM 01/01/2010 01/01/2011
?????

in Column (A), The employee Name
in Column (B), The Driving license issue Date
in Column (C), The Driving license Expire Date

In Column (D), I need a Formula that show me wither the employee’s driving
license is Valid or Expire, For Example; it will be valid until 01/01/2011.
When this date comes the Formula will change the result (The Cell) into
Expired.

Your help is highlight appreciated.

 

[Fred Smith]

In D1 use:
=if(c1<today(),"Expired","Valid")

Regards,
Fred

 

[FSt1]

hi
in c2 enter
=if B2<DATEVALUE("1/1/2011"),DATEVALUE("1/1/2011"),"Expired")

format c2 as date.

regards
FSt1

 

[ck13]

Not sure if you mean this, try pasting into D2
=IF(C2<TODAY(),"Expired","Valid")
If the date in C2 is less than today's date, D2 will shows "Expired" but if
C2 is more than today's date, it will shows valid. TODAY() is dynamic, it
will update itself everyday. If this is what you want, click yes below.

A B C
D
1 Name Issue date Expire date Status
2 qwe 01 January 2010 01 April 2010 Valid

 

[Khalid A. Al-Otaibi]

Thank you so much, this what I was looking for, but one more question. Can
the date be showen, while it's valid. If not valid, it will be the word
(Expired).

 

[ck13]

Sure, change the formula to the following
=IF(C2<TODAY(),"Expired",C2)

 

[ck13]

Sure, change to the following
=IF(C2<TODAY(),"Expired",C2)