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

Regards,
Fred

"Khalid A. Al-Otaibi" wrote in
message ...
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; Its more than one formulas, but I am sure
that
you can create it. Youre much better than me, and thank you in advance;

Lets 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 employees
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.