Announcement

Collapse
No announcement yet.

Break/Split Date Into Day, Month & Year

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Break/Split Date Into Day, Month & Year

    Hi
    In Column A, I have a date formatted as follows: 10/13/2007
    I want to break this out into three other columns as follows:
    Column B Month = 10
    Column B Day = 13
    Column B Year = 2007

    I need all three columns to be values that I can use in a VLOOKUP.

    Thanks
    LPS

  • #2
    Re: Breaking Out The Date

    You could use the following.

    Date Column A1 = 10/17/2009

    Column B1 would be: =MID(A1,1,2)
    Column C1 would be: =MID(A1,4,2)
    Column D1 would be: =MID(A1,7,4)

    *only works if cell format is TEXT.

    Comment


    • #3
      Re: Breaking Out The Date

      If A1 contains a date then you can use

      =DAY(A1)
      =MONTH(A1)
      =YEAR(A1)

      Comment


      • #4
        Re: Breaking Out The Date

        Data>Text to Columns...

        Comment


        • #5
          Re: Break/Split Date Into Day, Month & Year

          Thanks
          The last two solutions are great.
          I am struggling with the first as I am not able to turn the date to TEXT without it turning into a 30000 value

          LPS

          Comment

          Working...
          X