Get previous month from Date

  • I have a date written as 01-Feb-15. on cell E3


    I also have formula which says


    Code
    =CONCATENATE("For the month of ",TEXT(E3,"mmm-yy"))


    I get the text as
    For the month of Feb-15.


    But what I require is
    For the month of Dec-14.


    The date given above 01-Feb-15 and I would not like to change to December date.

  • Re: Get previous month from Date



    Can't understand why you are expecting the formula will return Dec-14


    The formula is just changing the data from Date to Text type...


    If you want to get previous month, you can try:


    =TEXT(EDATE(E3,-1),"mmm-yy")


    This will return Jan-15

    Best Regards,


    Tony


    [SIZE=1]A Peaceful Mine Is A Blessing[/SIZE]

  • Re: Get previous month from Date


    Try this:


    ="For the month of " &TEXT(EOMONTH(E3,-2),"mmm-yy") result is For the month of dec-14


    BUT previous month from Date of Feb-15 is Jan-15

  • Re: Get previous month from Date


    Quote from Tom.Jones;737467

    Try this:


    ="For the month of " &TEXT(EOMONTH(E3,-2),"mmm-yy") result is For the month of dec-14


    BUT previous month from Date of Feb-15 is Jan-15



    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!