Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the
format of ddmmmyy. I am trying to create two more columns of data, one containing the year, and one containing the month. Is it possible to use a formula to extract these without having to sort individually and input manually. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
Assume that your Date is in A1 cell
Copy and paste the below formula in B1 cell for getting the Month. =MONTH(A1) Or =TEXT(A1,"MMM") Copy and paste the below formula in C1 cell for getting the Year. =YEAR(A1) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "dwake" wrote in message ... I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing the year, and one containing the month. Is it possible to use a formula to extract these without having to sort individually and input manually. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
If they are true Excel dates try these.
For the month number: 1, 2, 3 ... 12 =MONTH(A1) For the short month name: Jan, Feb, Mar ... Dec =TEXT(A1,"mmm") For the long month name: January, February, March ... December =TEXT(A1,"mmmm") For the year: =YEAR(A1) -- Biff Microsoft Excel MVP "dwake" wrote in message ... I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing the year, and one containing the month. Is it possible to use a formula to extract these without having to sort individually and input manually. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
Hey !! Congrats on your Bronze level..
"Ms-Exl-Learner" wrote: Assume that your Date is in A1 cell Copy and paste the below formula in B1 cell for getting the Month. =MONTH(A1) Or =TEXT(A1,"MMM") Copy and paste the below formula in C1 cell for getting the Year. =YEAR(A1) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "dwake" wrote in message ... I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing the year, and one containing the month. Is it possible to use a formula to extract these without having to sort individually and input manually. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Dates
Thank you sir!!!
-------------------- (Ms-Exl-Learner) -------------------- "Jacob Skaria" wrote: Hey !! Congrats on your Bronze level.. "Ms-Exl-Learner" wrote: Assume that your Date is in A1 cell Copy and paste the below formula in B1 cell for getting the Month. =MONTH(A1) Or =TEXT(A1,"MMM") Copy and paste the below formula in C1 cell for getting the Year. =YEAR(A1) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "dwake" wrote in message ... I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the format of ddmmmyy. I am trying to create two more columns of data, one containing the year, and one containing the month. Is it possible to use a formula to extract these without having to sort individually and input manually. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting dates from a String | Excel Worksheet Functions | |||
Extracting Dates | Excel Discussion (Misc queries) | |||
Extracting Dates | Excel Worksheet Functions | |||
Extracting Dates | Excel Worksheet Functions | |||
date formula for extracting unique dates | Excel Worksheet Functions |