+ Reply to Thread
Results 1 to 5 of 5

Pulling the first two letter out of the month field

  1. #1
    Forum Contributor
    Join Date
    05-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    151

    Pulling the first two letter out of the month field

    I would like to pull the month from 11/22/1982. In this case the function should return 11. Is there a formula to do that?

    Thanks

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,374

    Re: Pulling the first two letter out of the month field

    Try the MONTH function.

    Like this:

    =MONTH("11/22/1982")

    or this:

    =MONTH(DATE(1982,11,22))

    or this:

    =MONTH(A1)
    where the date is in cell A1.

  3. #3
    Registered User
    Join Date
    06-14-2019
    Location
    Charlotte, NC, USA
    MS-Off Ver
    Office 365
    Posts
    10

    Re: Pulling the first two letter out of the month field

    If you want the actual letters... you can get it by LEFT ( TEXT( your date , "mmm") , 2)
    Last edited by izzy-analytics; 06-14-2019 at 02:25 PM.

  4. #4
    Forum Contributor
    Join Date
    05-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    151

    Re: Pulling the first two letter out of the month field

    wow nice the MONTH function is exactly what i need. Thanks!

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,374

    Re: Pulling the first two letter out of the month field

    You're welcome. Happy to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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