On Sep 28, 10:55*am, Ron Rosenfeld wrote:
On Tue, 28 Sep 2010 06:14:28 -0700 (PDT), gcotterl





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

And what is the result of the =TYPE(cell_ref) that joeu2004 asked you
to report?- Hide quoted text -

- Show quoted text -

==================================================

C =TYPE(cell_ref) result

06/28/1991 =TYPE(C1) 01/02/1900
06/25/1991 =TYPE(C2) 01/01/1900
05/13/1991 =TYPE(C3) 01/01/1900
06/21/1991 =TYPE(C4) 01/01/1900
06/30/1992 =TYPE(C5) 01/01/1900
11/07/1990 =TYPE(C6) 01/01/1900



G =TYPE(cell_ref) result
09-30-2003 =TYPE(G1) 2
09-30-2003 =TYPE(G2) 1
09-30-2003 =TYPE(G3) 1
09-30-2003 =TYPE(G4) 2
09-30-2003 =TYPE(G5) 2
09-30-2003 =TYPE(G6) 2