Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Most simple formula to calculate date+ 30 months? | Excel Worksheet Functions | |||
Need a formula to calculate the number of months to pay off a loan | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
how to calculate years, months by using one formula | Charts and Charting in Excel |