Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Display (Excel 2003)

    Hello

    I am doing date calculations on a spreadsheet. A date is displayed in this format: Mar-07, Apr-07, etc.

    In order to do the calculations I use the formula =CONCATENATE((MONTH(O31)+1),YEAR(O31)) to add 1 month (or 2) to the current month which results in an answer 42007, 62007 etc.

    How do I get 42007 to display as Apr-07? Or is there a better way to do the calculations?

    Any help or ideas will be appreciated

    Regards

  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: Date Display (Excel 2003)

    To display the serialdate as desired, Format the cell as:
    mmm-yy

    Steve

    PS: To add 1 month I would use:
    =date(year(o31),month(o31)+1,day(o31))

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

    Re: Date Display (Excel 2003)

    42007 is a concatenation of 4 (April) and 2007 - formatting it as mmm-yy won't display it as Apr-07 since it is not a date value.
    The formula in your PS does result in a date value, so it can be formatted as mmm-yy.

  4. #4
    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: Date Display (Excel 2003)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>I had a "brainfart" when I first posted and hadn't read it completely through. [I saw the 42007 and it looked like a serialdate ....]

    Steve

  5. #5
    Star Lounger
    Join Date
    Apr 2006
    Location
    Accra, Ghana
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Display (Excel 2003)

    Steve & Hans

    Thank you very much, that helps a lot.

    Regards

Posting Permissions

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