# Month's name to be changed after 15 th

• ### Question

• Hi,

The formula   " =TEXT(A1,"MMMM")"    in B1 gives name of month according to date in A1. I need it to modify to show month's name as follow's  " =IF(A1>="16-4-2014",IF(A1<="15-5-2014","MAY",0)), How to make it possible ? If date in A1 is 29-4-14, I want it to show May in B1.

It gives jan all way for this formula "=IF(B4>=16-4-2014,IF(B4<=15-5-2014,"May",))"

regards

• Edited by Sunday, September 14, 2014 8:20 PM
Sunday, September 14, 2014 8:09 PM

=TEXT(DATE(YEAR(A1),MONTH(A1)+(MONTH(A1)<>3)*(DAY(A1)>15),1),"mmmm")

Regards, Hans Vogelaar (http://www.eileenslounge.com)

• Marked as answer by Monday, September 15, 2014 8:13 AM
Monday, September 15, 2014 5:46 AM

### All replies

• Does this do what you want?

=IF(AND(A1>=DATE(2014,4,16),A1<=DATE(2014,5,15)),"May","")

Or would you like something like this?

=TEXT(DATE(YEAR(A1),MONTH(A1)+(DAY(A1)>15),1),"mmmm")

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Sunday, September 14, 2014 9:45 PM
• Hi,

Thank you both of them do. But I need some modification. For April it should be 1-4-14 to 15-4-14 and for march it should be 16-2-14 to 31-3-14. Rest of months are working nice.  So can we make =IF(AND(A1>=DATE(2014,4,16),A1<=DATE(2014,5,15)),"May","") for all 12 months in one formula ? With this choice for March and April ?

Thank you again,

regards

dockhem

• Edited by Monday, September 15, 2014 4:47 AM
Monday, September 15, 2014 12:48 AM

=TEXT(DATE(YEAR(A1),MONTH(A1)+(MONTH(A1)<>3)*(DAY(A1)>15),1),"mmmm")

Regards, Hans Vogelaar (http://www.eileenslounge.com)

• Marked as answer by Monday, September 15, 2014 8:13 AM
Monday, September 15, 2014 5:46 AM
• Hi Hans Vogelaar,

It is excellent I could get. Thanks a lot.

regards

dockhem

• Edited by Monday, September 15, 2014 9:19 AM
Monday, September 15, 2014 8:13 AM
• Monday, September 15, 2014 9:18 AM
• I looked at that thread, but I don't understand it, sorry.

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Monday, September 15, 2014 5:18 PM
• Thank you, Hans Vogelaar for your kindness,

regards

dockhem

Tuesday, September 16, 2014 12:13 AM