locked
Month's name to be changed after 15 th RRS feed

  • 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",))"

    Please help in this.

    regards


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

Answers

  • How about

    =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 dockhem2 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 dockhem2 Monday, September 15, 2014 4:47 AM
    Monday, September 15, 2014 12:48 AM
  • How about

    =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 dockhem2 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 dockhem2 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