Complicated Formula to Distinguish, weather the License is Valid o
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.
|