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.

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.

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

format c2 as date.

regards
FSt1

"Khalid A. Al-Otaibi" wrote:

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.

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" wrote:

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.

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" wrote:

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" wrote:

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.

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


"Khalid A. Al-Otaibi" wrote:

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" wrote:

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" wrote:

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.

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

"Khalid A. Al-Otaibi" wrote:

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" wrote:

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" wrote:

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.