Thread: Convert dates
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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