On 2002-02-24 13:01, Aladin Akyurek wrote:
On 2002-02-24 12:41, pilot wrote:
Short of a lookup table, how can I get date functions to read 3 char text (JAN, FEB ...) as month number (1, 2...)?
=MATCH(A1,{"jan";"feb";"mar";"apr";"may";"jun";"jul";"aug";"sep";"oct";"nov";"dec"},0)
will do.
I reckon the formula that you use in your cond format setup is why you're asking for this.
Did you know that, given a date, you can test whether that date is a date e.g., in "Jan" by using:
=TEXT(A1,"mmm")="Jan"
Aladin
PS. I have still a hard time to visualize the lay-out of your worksheet to which you want to apply cond format.