Share via

Excel Month/Day extracted from YYYYMMDD

Anonymous
2018-11-02T16:36:05+00:00

I am trying to pull the month and day from YYYYMMDD into another cell in excel, any help is much appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2018-11-02T18:18:06+00:00

    That depends:  is the value of the truly the integer 20181102, for example?  Or is really a date (11/02/2018, for example), and it merely appears to be 20181102 due to a cell format?

    If it is really a date, use MONTH(A1) and DAY(A1) to "extract" the month and day numbers.  Use TEXT(A1,"mmmm") and TEXT(A1,"dddd") to "exact" the month and day names.

    If it is the integer 20181102, use --MID(A1,5,2) and MOD(A1,100) to "extract" the month and day numbers.  The double negate ("--") converts text to number.

    6 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-11-02T18:02:01+00:00

    To extract Month from YYYYMMDD

    =MID(A2,5,2)

    To extract Day from YYYYMMDD

    =RIGHT(A2,2)

    4 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-02T18:08:40+00:00

    Hi Elizabeth_315,

    According to your description, we understand you want to extract the month and day from dates.

    You may try the following formula:

    =MONTH(A1)&DAY(A1)

    If you want a delimiter between month and day, try this formula:   =MONTH(A1)&"/"&DAY(A1)

    Regards,

    Tina

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-11-03T22:19:44+00:00

    Hi Elizabeth_315,

    Feel free to share any update with us after you refer to the suggestions.

    Thanks,

    Tina

    0 comments
  3. Anonymous
    2018-11-02T16:45:06+00:00

    hi i am andresr

    can you follow this and change format

    https://support.office.com/en-us/article/format...

    regards

    0 comments