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! |
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 |