Hello,

I'm having an issue with dates (no, it's not a social problem, ha ha -- too
corny?). I have to determine what the month is for each date in a column,
and then insert that month into another cell. If the month is January
through September, i.e., 1 through 9, I need to insert that single digit into
this other cell; however if the month is October, November or December, I
need a special character to be inserted. October should be represeneted as
"}", November as "-" and December as "&". (These are the requirements of a
data file for a third party).

I wanted to do LEFT function combined with VLOOKUP to get the corresponding
values, but the way Excel stores dates is foiling my plan! Does anyone have
any suggestions? Any help is very appreciated.