Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Show Only Month Name In Date Cells

  1. #1
    Join Date
    21st May 2008
    Posts
    3

    Show Only Month Name In Date Cells

    Hi, forgive me, this is my first post. I need assistance with the following date range scenario: I have a date field where the user enters a date. I want the next field to automatically give the month of that date for example: user enters 01/01/2008 I want the next field to automatically say "JAN" etc. I know this is probably quite basic but it would be really helpful if someone could tell me how this is achieved. Many thanks
    Auto Merged Post Until 24 Hrs Passes;

    apologies again - have answered my own question by formatting the target cells as MMMM
    Last edited by kategorgeous; May 22nd, 2008 at 00:20. Reason: Auto Merged Doublepost

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th February 2008
    Posts
    74

    Re: Date Range Resulting In Month Calculation

    Just copy the date to the next field. Then,
    -Right click...Format Cells
    -'Number' Tab
    -Select 'Custom' from the list on the left
    -Enter "mmm" under 'Type'
    -Click 'OK'

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    21st May 2008
    Posts
    3

    Re: Date Range Resulting In Month Calculation

    Hi - massive thanks for the quick reply. The problem with this solution is it messes up my pivot tables. I have a pivot table which references the month and now that it has become a date (even thought it looks like a month) the table is too large - hope this makes sense! Basically I need these cells to actually say "MAY" rather than 01/05/08.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Six Strings Guest

    Re: Date Range Resulting In Month Calculation

    I'm not 100% clear on how you're using this but the following will give you a true text field. I am a little confused by the comment you made in the automerge vs. your last post, as to whether you have already solved your problem or not.

    =CHOOSE(MONTH(A1),"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Date Range Resulting In Month Calculation

    Custom Format the date source AND the PivotTable field as "MMM" or Group by Month.

  6. #6
    Join Date
    21st May 2008
    Posts
    3

    Re: Show Only Month Name In Date Cells

    Many thanks wonderful people. Problem resolved.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Date To Show As Month
    By sriya in forum Excel and/or Access Help
    Replies: 3
    Last Post: March 25th, 2008, 12:43
  2. Show Month Of Date Added In Cell
    By kitvel in forum EXCEL HELP
    Replies: 3
    Last Post: March 20th, 2008, 18:24
  3. Show Weekday Of Date Cells
    By Izzi in forum EXCEL HELP
    Replies: 4
    Last Post: December 6th, 2006, 14:12
  4. Count Date Cells Where Date Is Previous Month
    By tabman in forum EXCEL HELP
    Replies: 18
    Last Post: October 26th, 2006, 05:16
  5. Determine begin month date from month end date.
    By mikeburg in forum EXCEL HELP
    Replies: 3
    Last Post: January 14th, 2006, 05:43

Bookmarks

Posting Permissions

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