Formula convert date to month format

[Raine]

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!

 

[Gary''s Student]

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.

 

[muddan madhu]

try this

=IF(DAY(B1)>15,"End "&TEXT(B1,"mmm"),"Mid "&TEXT(B1,"mmm"))

 

[Teethless mama]

=IF(DAY(A2)<16,"Mid ","End ")&TEXT(A2,"mmm")

 

[Raine via OfficeKB.com]

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

 

[Raine via OfficeKB.com]

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

 

[Raine via OfficeKB.com]

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!

 

[Raine via OfficeKB.com]

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!