+ Reply to Thread
Results 1 to 9 of 9

Modifying Date/Time stamped value to calculate Days Since

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Modifying Date/Time stamped value to calculate Days Since

    Hi,
    My data set contains 'Order Date' (Day/Month/Year format) in col 'A' and 'Shipped to Store Date' (which is a date/time stamp combination) col 'B'. I would like to calculate the 'Days Since Order' col 'C' but cannot seems to figure out how to break and re-format the Ship to Date value.

    Also, unsure if this is best done through vba or formula.

    Any guidance would be appreciated.

    Order Date ShippedToStore Date Days Since Order
    6/27/2013 Sat 29 Jun 2013 14:45:18
    6/27/2013 Sat 29 Jun 2013 14:45:18
    7/9/2013 Wed 10 Jul 2013 15:00:38
    7/14/2013 Tue 16 Jul 2013 15:00:50
    7/14/2013 Tue 16 Jul 2013 15:00:50

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Modifying Date/Time stamped value to calculate Days Since

    If these are real excel dates....you can tell by choosing an empty cell and typing =ISNUMBER(CELL) and it should come back as true...if it is try this

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Modifying Date/Time stamped value to calculate Days Since

    Hi Ernest,
    These are not real excel dates and I tried the formula above and it returned FALSE. Any other suggestions on how I can convert these values into dates?

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Modifying Date/Time stamped value to calculate Days Since

    can you upload a file with the dates?....it's really hard to figure out which parts of the dates are in which column....thanks

  5. #5
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Modifying Date/Time stamped value to calculate Days Since

    Quote Originally Posted by judgeh59 View Post
    can you upload a file with the dates?....it's really hard to figure out which parts of the dates are in which column....thanks
    Book2.xlsx- Here you go

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Modifying Date/Time stamped value to calculate Days Since

    give this a try

    Please Login or Register  to view this content.
    and by the way....the Order date column are real excel dates....

  7. #7
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Modifying Date/Time stamped value to calculate Days Since

    this will also work

    Please Login or Register  to view this content.
    format column C as numbers....

  8. #8
    Registered User
    Join Date
    11-07-2012
    Location
    SF, US
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Modifying Date/Time stamped value to calculate Days Since

    Apologies for my confusion... this is EXACTLY what i needed! Thank you

  9. #9
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Modifying Date/Time stamped value to calculate Days Since

    not a problem....glad I could help....

+ 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. Replies: 3
    Last Post: 11-24-2012, 03:19 PM
  2. Replies: 1
    Last Post: 09-13-2012, 05:50 AM
  3. Replies: 0
    Last Post: 09-13-2012, 05:28 AM
  4. Replies: 1
    Last Post: 11-02-2011, 06:50 PM
  5. Replies: 1
    Last Post: 11-02-2011, 06:44 PM

Tags for this Thread

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