+ Reply to Thread
Results 1 to 7 of 7

Split Date in two Columns

  1. #1
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Split Date in two Columns

    I have to convert a full date, to just show year and month.

    Column A has date the 4/27/2017 , I need a formula in Column B to show only the year (2017) and column C to show only the month (April)

    Thank you, LaDonna

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Split Date in two Columns

    Column B:
    =Year(A2)

    Column C:
    =TEXT(A2, "mmmm")

  3. #3
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: Split Date in two Columns

    Thank you !!!

  4. #4
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: Split Date in two Columns

    Another question, how do I prevent 1900 from showing in the blank cells?

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Split Date in two Columns

    You use IF function.

    =IF(A2="","",YEAR(A2))

  6. #6
    Forum Contributor
    Join Date
    04-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    101

    Re: Split Date in two Columns

    Ohhh.. got it.. THANK YOU !!

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Split Date in two Columns

    You are welcome and thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula(s) to Split Text String Across Columns Using Columns as Seperator
    By WaylettChris in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2016, 01:13 PM
  2. Column Contains Date and Item Codes, Need to Split these into two columns
    By adakos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2015, 07:45 PM
  3. [SOLVED] How do I split the date & time into two separate columns?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-22-2014, 03:26 PM
  4. Split uneven data from a single columns to multiple columns
    By pfoz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-13-2013, 08:24 AM
  5. How to split a date in different Columns ?
    By abhi.shukla15 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-31-2013, 12:39 PM
  6. Split date into 3 separate columns
    By paulr24 in forum Excel General
    Replies: 4
    Last Post: 01-25-2012, 01:51 PM
  7. [SOLVED] Split a date/time column into 2 columns
    By RKMiller in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 12:10 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1