+ Reply to Thread
Results 1 to 4 of 4

Help on count the number of days in between dates and then average number of days

  1. #1
    Registered User
    Join Date
    05-15-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007, Excel MAC 2008
    Posts
    64

    Help on count the number of days in between dates and then average number of days

    I have a problem I would appreciate some help with.
    I have a number of entries in a database, with dates against then for each customer. Say they are order dates.
    I need to find the average number of days between each order for the customer, and then the average for the customer and rrepeat this for my whole data set ending up with an average length of time in between orders

    sanitised data attached

    any help appreciated

    Barbara
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Help on count the number of days in between dates and then average number of days

    Can you type in the expected results where you wish to place.
    In B3, you mean year 2012 instead of 2013?
    Quang PT

  3. #3
    Registered User
    Join Date
    05-15-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007, Excel MAC 2008
    Posts
    64

    Re: Help on count the number of days in between dates and then average number of days

    Hey there I have uploaded the file an indeed i meant 2012 instead of 2013
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Help on count the number of days in between dates and then average number of days

    What is your designed results?
    For instance, abc124 has 3 orders on 1/1/2012,8/5/2012,9/9/2012, the average days is (9/9/2012-1/1/2012)/2=126 days?
    In general, (last date-first date)/(number of orders-1)
    Is that right?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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