Thread: Convert dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
 
Posts: 83
Default Convert dates

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.