need if formula for 12 months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you both for your help! This worked perfectly. Sometimes the simplist
things elude me..... :-)
 
Back
Top