Convert dates
"gcotterl" wrote in message
...
The cells in Col C contain:
06/28/1991
06/25/1991
05/13/1991
06/21/1991
06/30/1992
11/07/1990
In Format Cells:
"Category" = Custom
"Type" = mm/dd/yyyy
===================
The cells in Col G contain:
09-30-2003
10-20-2005
09-30-2003
09-30-2003
04-07-2000
06-06-2003
In Format Cells:
"Category" = General
(The first two digits is the Month; the middle two digits is the Day;
the last four digits is the Year)
===============
I want to determine if G1 is after (i.e., greater than) C1.
=G1C1
will work if the cells contain dates. No further conversion needed.
HTH. Best wishes Harald
|