Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    May 2008
    Location
    Iowa, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formulas (Excel 2003)

    I am trying to write a formula that puts in MMMYY (FEB09) in a column based off of dates entered into another column. I have used the IF statement combined with the LEFT statement before, but can not seem to get it to work for this. Any ideas??

    Thanks a bunch!
    Richenda
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formulas (Excel 2003)

    How about:
    =IF(MONTH(F1)=2,"FEB09","No")

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Steve,
    I was having a go at this myself..... without success. Out of interest, why does:

    =LEFT(F1,2) return 39
    &
    =MID(F1,4,2) return 57.

    I'm guesstig that it is to do with the formatting?

  4. #4
    Lounger
    Join Date
    May 2008
    Location
    Iowa, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    You are correct, it has to do with the formatting of the cell being a date format.

  5. #5
    Lounger
    Join Date
    May 2008
    Location
    Iowa, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Thanks - that works, now how do I get the full year in the formula. It errors out on me after JUL09. I can not string any more together after 7 of them.

    Richenda

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formulas (Excel 2003)

    How about

    =UPPER(TEXT(F1,"mmmyy"))

  7. #7
    Lounger
    Join Date
    May 2008
    Location
    Iowa, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Hans - you are my man! That takes care of everything.

    Thanks so much.
    Richenda

  8. #8
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    If you went to display the date as FEB09 you could use:
    =UPPER(TEXT(F1,"MMMYY"))
    if you don't mind having lower case in the cell you can use a custom formatting for the cell of:
    mmmyy

  9. #9
    Lounger
    Join Date
    May 2008
    Location
    Iowa, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003)

    Thanks for the hint - I will keep that in mind! Lord knows what I would do without you people helping me out.
    Richenda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •