Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blopreste3180
 
Posts: n/a
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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!



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blopreste3180
 
Posts: n/a
Default 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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Most simple formula to calculate date+ 30 months? KR Excel Worksheet Functions 4 September 28th 05 07:57 PM
Need a formula to calculate the number of months to pay off a loan kv Excel Discussion (Misc queries) 2 August 2nd 05 09:02 PM
Why "datedif" function results sometimes negative numbers? Ambrosiy Excel Worksheet Functions 1 July 8th 05 11:29 AM
how to calculate years, months by using one formula srinivasa rao Charts and Charting in Excel 2 April 15th 05 08:28 AM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"