Help with Dates
Kassie,
Thanks for the response. Are you saying the conditional format is right I
just don't have my column formated right? I need the cells column I2 to
change a color if they are expire before the dates in J2?
"kassie" wrote:
Whether I format cells a Custom dd-mmm, as Date 2001-03-14 or as date
14-03-2001, or wether I format as any combination of these, it works for me?
--
Hth
Kassie Kasselman
Change xxx to hotmail
"relo rob" wrote:
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!
|