Results 1 to 6 of 6

Extract month from date, have it display as 'Jan', and have excel read it as a month.

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    97

    Extract month from date, have it display as 'Jan', and have excel read it as a month.

    I have a date. 1/1/2019. I can reference the cell and extract the date using =month(A1). It'll show as a 1.

    Is there a way to show that as Jan, but also have excel read it as a month? So when I filter on the column, the months aren't in alphabetical order, they are instead in order of the calendar.

    Currently, everything I have tried excel wants to put it in alphabetical order.

    Thanks
    Last edited by kufta4; 01-25-2019 at 12:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 05-17-2016, 05:32 PM
  2. [SOLVED] Change date in excel formulas from month to month automatically
    By ANDREAAS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-02-2013, 09:34 AM
  3. [SOLVED] Display the first date of the month when the month and year are selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 11:59 AM
  4. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  5. [SOLVED] IF statement to read month format and place month name in next cell
    By david1987 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2012, 11:41 AM
  6. Display end of month date for previous month
    By erikwvb in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 01:22 PM
  7. Replies: 5
    Last Post: 06-17-2010, 02:45 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1