Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Separate in Excel Dates in to 3 different cells

Posted on 2011-03-10
Medium Priority
212 Views
Hello,

I have a roster with a Birthdays in one cell   examples 2/13/2011  and I need to separate the date in 3 cell example  2       13           2010  does anybody know how I can do this I tried = right 4 and it give me a weird number.
0
Question by:LENERO
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 24

Expert Comment

ID: 35098135
use:
=Day(A1)

=Month(A1)

=year(A1)
0

LVL 24

Accepted Solution

jimyX earned 2000 total points
ID: 35098185
Assuming you have your Dates in A1 and down and you want the Day/Month/Year in the next columns, then:
in A1 you have "2/13/2011"
in B1 put "=Day(A1)"
in C1 put "=Month(A1)"
in D1 put "=Year(A1)"
Then copy columns B, C & D down to cover the Birthdays you have in column A.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month6 days, 5 hours left to enroll