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!

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

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!

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!