| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula convert date to month format
Gary''s Student wrote:
With your data in column A, in B1 enter: =MID(A1,SEARCH(" ",A1&" ",SEARCH(" ",A1&" ",1)+1)+1,SEARCH(" ",A1 & " ",SEARCH(" ",A1&" ",SEARCH(" ",A1&" ",1)+1)+1)-SEARCH(" ",A1&" ",SEARCH(" ",A1&" ",1)+1)-1) and copy down. Hi Gary, thank you for the formula. I just encountered some problem with it. A message prompted "You entered too many arguments for this function. I need your help... [quoted text clipped - 22 lines] Thank you! -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Convert date to number representing Month | Excel Discussion (Misc queries) | |||
| Convert date field to month in Pivot table | Excel Discussion (Misc queries) | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
Hybrid Mode
