+ Reply to Thread
Results 1 to 2 of 2

Finding the average?. We deliver x many of days a week out of a possible x

  1. #1
    Registered User
    Join Date
    03-28-2019
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    1

    Unhappy Finding the average?. We deliver x many of days a week out of a possible x

    Hi All!

    i have a list of customers, we could deliver to them up to 4 times a week (a possible 208 days a year) but they have ordered X amount of times within a year. (the dockets per year)
    So under AV Weekly orders, i would like to work out how many times they are getting an order on a weekly average. i am going OUT OF MY MIND
    SOS xoxoSOS.png

    EG. Store 1 got 19 deliveries in 1 year, they could have had 208.. what is the formula needed to give a weekly average

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Finding the average?. We deliver x many of days a week out of a possible x

    If I'm understanding correctly: If you have 19 deliveries per year that's 19 in 52 weeks and so an average of 19/52 per week. = an average of 0.365 deliveries / wk.

+ 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] Finding average amount of days
    By DAVE201992 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2018, 04:05 AM
  2. Finding one of two specific days of the week
    By NickSBaker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2017, 03:19 PM
  3. [SOLVED] Finding number of days between dates and categorising by week ending date
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2016, 07:42 AM
  4. how to calculate days worked for an average over a five week period
    By Nicky_B in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 11:28 AM
  5. Average of first three days of the week
    By goodboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-09-2014, 01:25 PM
  6. Replies: 1
    Last Post: 08-25-2010, 11:25 AM
  7. [SOLVED] How can I add up lookups? Finding days in a week of a month
    By Michael at Thin Air in forum Excel General
    Replies: 5
    Last Post: 01-29-2006, 02:55 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