| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula convert date to month format
I need your help...
What is the correct formula if I need to convert the date to a text value in a month format? I have two columns the DATE column and then the MONTH column. Date - particular date in a month with MM/DD/YYYY value Month - Mid Month if the date will fall from 1-15 and the End Month if it is 16-31. Example: Date Month 09/01/2008 Mid Sep 09/02/2008 Mid Sep 09/15/2008 Mid Sep 09/16/2008 End Sep 09/29/2008 End Sep 09/30/2008 End Sep 10/01/2008 Mid Oct 10/02/2008 Mid Oct 10/14/2008 Mid Oct 10/15/2008 Mid Oct 10/16/2008 End Oct 10/17/2008 End Oct 10/22/2008 End Oct Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
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. -- Gary''s Student - gsnu200856 "Raine" wrote: I need your help... What is the correct formula if I need to convert the date to a text value in a month format? I have two columns the DATE column and then the MONTH column. Date - particular date in a month with MM/DD/YYYY value Month - Mid Month if the date will fall from 1-15 and the End Month if it is 16-31. Example: Date Month 09/01/2008 Mid Sep 09/02/2008 Mid Sep 09/15/2008 Mid Sep 09/16/2008 End Sep 09/29/2008 End Sep 09/30/2008 End Sep 10/01/2008 Mid Oct 10/02/2008 Mid Oct 10/14/2008 Mid Oct 10/15/2008 Mid Oct 10/16/2008 End Oct 10/17/2008 End Oct 10/22/2008 End Oct Thank you! |
|
#3
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
try this
=IF(DAY(B1)15,"End "&TEXT(B1,"mmm"),"Mid "&TEXT(B1,"mmm")) On Jun 5, 1:53*pm, "Raine" <u52393@uwe wrote: I need your help... What is the correct formula if I need to convert the date to a text value in a month format? I have two columns the DATE column and then the MONTH column. Date - particular date in a month with MM/DD/YYYY value Month - Mid Month if the date will fall from 1-15 and the End Month if it is 16-31. Example: Date * * * * * * * * * *Month 09/01/2008 * * *Mid Sep 09/02/2008 * * *Mid Sep 09/15/2008 * * *Mid Sep 09/16/2008 * * *End Sep 09/29/2008 * * *End Sep 09/30/2008 * * *End Sep 10/01/2008 * * *Mid Oct 10/02/2008 * * *Mid Oct 10/14/2008 * * *Mid Oct 10/15/2008 * * *Mid Oct 10/16/2008 * * *End Oct 10/17/2008 * * *End Oct 10/22/2008 * * *End Oct Thank you! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
muddan madhu wrote:
try this =IF(DAY(B1)15,"End "&TEXT(B1,"mmm"),"Mid "&TEXT(B1,"mmm")) I need your help... [quoted text clipped - 22 lines] Thank you! Hi muddan madhu, I tried it and it works. Thank you so much! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200906/1 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
=IF(DAY(A2)<16,"Mid ","End ")&TEXT(A2,"mmm")
"Raine" wrote: I need your help... What is the correct formula if I need to convert the date to a text value in a month format? I have two columns the DATE column and then the MONTH column. Date - particular date in a month with MM/DD/YYYY value Month - Mid Month if the date will fall from 1-15 and the End Month if it is 16-31. Example: Date Month 09/01/2008 Mid Sep 09/02/2008 Mid Sep 09/15/2008 Mid Sep 09/16/2008 End Sep 09/29/2008 End Sep 09/30/2008 End Sep 10/01/2008 Mid Oct 10/02/2008 Mid Oct 10/14/2008 Mid Oct 10/15/2008 Mid Oct 10/16/2008 End Oct 10/17/2008 End Oct 10/22/2008 End Oct Thank you! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
Teethless mama wrote:
=IF(DAY(A2)<16,"Mid ","End ")&TEXT(A2,"mmm") I need your help... [quoted text clipped - 22 lines] Thank you! Thank you for the help. It really works.. Have a nice day! =) -- Message posted via http://www.officekb.com |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula convert date to month format
Teethless mama wrote:
=IF(DAY(A2)<16,"Mid ","End ")&TEXT(A2,"mmm") I need your help... [quoted text clipped - 22 lines] Thank you! Thank you for the help. It really works.. Have a nice day! =) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200906/1 |
| 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
