+ Reply to Thread
Results 1 to 6 of 6

change dates (split up) and use date only

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    change dates (split up) and use date only

    hi
    i have used text to columns to split up a date ,j column i moved to z column and used text to columns to split into 3 ie wed /thursday/0800hrs ,my problem is i want to auto arrange column j in day and date not bothered about the time ,when i expand selection to cover full sheet it moves up one row and puts everything out,my intension was to put the sheet in order and then copy mon to mondays sheet ,tues to tuesdays sheet ect but are having problems knowing the best way
    each week i have a down load that i enter in load data and send to sheet 2 after applying filter in macro2 which works well
    its only the last bit of sorting day and date in order and sending to appropiate sheets ,has any one got any ideas as best way to do
    cheers colin
    Last edited by cfinch100; 12-28-2016 at 03:03 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: change dates (split up) and use date only

    If Cell A3 has your date, maybe like so
    Monday, March 14, 2016

    These
    Please Login or Register  to view this content.
    will result in this
    March
    Monday
    14
    2016

    Is that what you need to do?

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: change dates (split up) and use date only

    Please be more specific about sheet names and ranges. Neither can I see where you have split a date/time into two columns, nor indeed what you mean by wanting to 'arrange' (do you mean SORT) column J in day & Date. A date number will naturally be sorted in order of dates and a day is merely a different format of whatever the date number is.

    Tell us exactly what you are starting with, i.e. sheet/range references and what you want to end up with.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: change dates (split up) and use date only

    hi
    "load data" is the start commandbutton3 runs macro2 and sorts data and sends to "sheet2" as you can see column j is now just the date; but in column" aa" it is "wed-24/02/2015-0800
    what I need is to put column "j" in order lowest to highest (27/02/2016 next 28/02/2016 ) then copy all wed to sheet "Wednesday"all thur to sheet "thursday" for all week days
    hope this helps
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 12-28-2016 at 03:02 PM.

  5. #5
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: change dates (split up) and use date only

    hi
    I used macro msort to split date in column "aa"
    cheers

  6. #6
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    Re: change dates (split up) and use date only

    hi
    i have managed to split the day /date up now
    what i need is to transfer from sheet2 all j column that contains [wed] to sheet wednesday and all j column that contains [thur] to sheet thursday ect ect
    the macro i used is macrowed and macrothu ,but for some reason it is not tranferring the data can anyone help please
    cheers colin
    Attached Files Attached Files

+ 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. [SOLVED] cant get dates that are in text for to change to date form
    By superchew in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-04-2016, 12:13 AM
  2. [SOLVED] An updating date that doesn't change previous dates
    By DC93 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-22-2016, 06:53 AM
  3. Replies: 12
    Last Post: 06-13-2014, 05:03 PM
  4. How to change dates if the date overlaps
    By redza in forum Excel General
    Replies: 3
    Last Post: 09-30-2013, 12:37 AM
  5. Split date period into seperate dates
    By Sivran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 06:26 AM
  6. Change all dates in a specific date range
    By akhilash in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2009, 01:01 PM
  7. Change date in one box, all dates change
    By kngabe in forum Excel General
    Replies: 4
    Last Post: 06-27-2008, 09:43 AM

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