Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Break/Split Date Into Day, Month & Year

  1. #1
    Join Date
    15th September 2005
    Posts
    38

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th May 2008
    Posts
    6

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th April 2007
    Location
    England
    Posts
    675

    Re: Breaking Out The Date

    If A1 contains a date then you can use

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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

  5. #5
    Join Date
    15th September 2005
    Posts
    38

    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

    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. Rolling Year-to-Date Sum By Month Chosen
    By calimero1 in forum EXCEL HELP
    Replies: 3
    Last Post: June 20th, 2008, 10:50
  2. Summarize By Month & Year to Date
    By Gizzmo in forum EXCEL HELP
    Replies: 3
    Last Post: July 11th, 2007, 11:54
  3. Date & Month & Year
    By adaleh in forum EXCEL HELP
    Replies: 3
    Last Post: July 31st, 2006, 12:58
  4. Basing a form off of the year/month of a date?
    By rmullen in forum Excel and/or Access Help
    Replies: 1
    Last Post: January 5th, 2006, 22:19
  5. determining the month and year of a date
    By nubs in forum EXCEL HELP
    Replies: 3
    Last Post: September 13th, 2005, 08:33

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