C
Craig A.
Hi!
I am using Excel 2003. In cell A1 I have the Current Date.
In Column E3 ( DATE CERTIFIED) I have a date entered that shows when a
person was Certified.
Column E4 (DATE EXPIRES) I want to show the date that the person was
certified in a Mont Year Format. (No Problem, I succeeded in that part of it)
and if has been over a year using A1 or Today's Date, I want the word EXPIRED
to appear where the date once was.
I have played with many veriations of the formula and have gone to online
help etc and have had no success. I really want to use a Spreadsheet and not
a Database for other reasons,. Can what I am asking be done?
Thanks for the help
DATE CERTIFIED DATE EXPIRES
Mar 07 EXPIRED
Apr 08 Apr 09
Jun 08 Jun 09
Mar 09 Mar 10
Dec 08 Dec 09
Aug 07 EXPIRED
Thank you
I am using Excel 2003. In cell A1 I have the Current Date.
In Column E3 ( DATE CERTIFIED) I have a date entered that shows when a
person was Certified.
Column E4 (DATE EXPIRES) I want to show the date that the person was
certified in a Mont Year Format. (No Problem, I succeeded in that part of it)
and if has been over a year using A1 or Today's Date, I want the word EXPIRED
to appear where the date once was.
I have played with many veriations of the formula and have gone to online
help etc and have had no success. I really want to use a Spreadsheet and not
a Database for other reasons,. Can what I am asking be done?
Thanks for the help
DATE CERTIFIED DATE EXPIRES
Mar 07 EXPIRED
Apr 08 Apr 09
Jun 08 Jun 09
Mar 09 Mar 10
Dec 08 Dec 09
Aug 07 EXPIRED
Thank you