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!