Formatting Dates
 

I have a list of all the months in Colm A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.

Formatting Dates
 

format==custom="mmm"

"Jordan" wrote:

I have a list of all the months in Colm A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.

Formatting Dates
 

or "MMMM" if want full name

"Jordan" wrote:

I have a list of all the months in Colm A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.

Formatting Dates
 

Thank You so much. I was using a cheater colm and this makes the formula
much cleaner.

"Toppers" wrote:

or "MMMM" if want full name

"Jordan" wrote:

I have a list of all the months in Colm A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.

Formatting Dates
 

A1:A3 - enter 01/05/2007; 2/15/2007; 3/20/2007

Highlight A1:A3 Format, Cells, Custom, (In the Box enter) mmmm
Ok Gives you January, February March

B1:B3 =Month(A1); =Month(A2); =Month(A3)
Gives you 1 2 3

HTH

"Jordan" wrote in message
:

I have a list of all the months in Column A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.