Solved

Separate in Excel Dates in to 3 different cells

Posted on 2011-03-10
2
206 Views
Last Modified: 2012-05-11
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
Comment
Question by:LENERO
  • 2
2 Comments
 
LVL 24

Expert Comment

by:jimyX
ID: 35098135
use:
=Day(A1)

=Month(A1)

=year(A1)
0
 
LVL 24

Accepted Solution

by:
jimyX earned 500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question