Date problem
 

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.

Date problem
 

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,"}","-","&")

--
Regards

Roger Govier


"ehale" wrote in message
...
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.

Date problem
 

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



"ehale" wrote:

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.

Date problem
 

Thanks Roger, this works perfectly!

"Roger Govier" wrote:

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,"}","-","&")

--
Regards

Roger Govier


"ehale" wrote in message
...
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.