need if formula for 12 months
 

I need a formula that will return a month name based on the date entered. For
example:
A B
1 10/12/05 RETURN value of Oct 05
2 06/01/05 RETURN value of Jun 05

So column A is the date and I want the value in column B to be the Month
name and year of Column A. I need this for every month of the year, but the
formula needs to be copied down about 3,000 rows of a spreadsheet to
determine each column A's result. Any quick help is appreciated!

need if formula for 12 months
 

Depending on what you are trying to accomplish....

B1 = TEXT(A7,"mmm yy") Note: this is a text result not a date so you
won't be able to use it in date functions.

B1 =DATE(YEAR(A7),MONTH(A7),1) Note: returns a data value equal to the
first day of the month. Can be used in formulas. Use Cell format to
display as mmm yy.

Personal Note: Whenever possible, I stick with date values since they
allow use of math functions.

- John Michl

need if formula for 12 months
 

Hi!

If you want the result to be a TEXT string:

=TEXT(A1,"MMM YY")

If you just want the displayed MMM YY:

=A1

Custom format as MMM YY

Biff

"blopreste3180" wrote in message
...
I need a formula that will return a month name based on the date entered.
For
example:
A B
1 10/12/05 RETURN value of Oct 05
2 06/01/05 RETURN value of Jun 05

So column A is the date and I want the value in column B to be the Month
name and year of Column A. I need this for every month of the year, but
the
formula needs to be copied down about 3,000 rows of a spreadsheet to
determine each column A's result. Any quick help is appreciated!

need if formula for 12 months
 

Thank you both for your help! This worked perfectly. Sometimes the simplist
things elude me..... :-)

"Biff" wrote:

Hi!

If you want the result to be a TEXT string:

=TEXT(A1,"MMM YY")

If you just want the displayed MMM YY:

=A1

Custom format as MMM YY

Biff

"blopreste3180" wrote in message
...
I need a formula that will return a month name based on the date entered.
For
example:
A B
1 10/12/05 RETURN value of Oct 05
2 06/01/05 RETURN value of Jun 05

So column A is the date and I want the value in column B to be the Month
name and year of Column A. I need this for every month of the year, but
the
formula needs to be copied down about 3,000 rows of a spreadsheet to
determine each column A's result. Any quick help is appreciated!