Thread: Help with Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
relo rob[_2_] relo rob[_2_] is offline
external usenet poster
 
Posts: 9
Default Help with Dates

I have two columns starting at I2 and J2. I need a formula that will tell me
what dates in I2 come before or expire before those in J2. Right now I have
the columns formatted as Number, Date, 03/14/2001. I have tried =(I2<J2) but
that is not working and I guess it's because I am comparing dates and not
#'s.

Help!