Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

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

1. Member
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. Banned
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. ## 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. ## Re: Breaking Out The Date

Data>Text to Columns...

5. Member
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

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

#### 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