Date problem

E

ehale

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.
 
R

Roger Govier

Hi

Assuming the dates are in column a and are true Excel dates, then
=CHOOSE(MONTH(A1),1,2,3,4,5,6,7,8,9,"}","-","&")
 
J

Jaleel

Hi,

Assuming that date in A1, put the formula in B1:

=IF(MONTH(A1)=12,"&",(IF(MONTH(A1)=11,"-",IF(MONTH(A1)=10,"{",MONTH(A1)))))

Then copy and paste value column B.

Hope this helps.

Regards,

Jaleel
 
E

ehale

Thanks Roger, this works perfectly!

Roger Govier said:
Hi

Assuming the dates are in column a and are true Excel dates, then
=CHOOSE(MONTH(A1),1,2,3,4,5,6,7,8,9,"}","-","&")
Click to expand...
 
Top