Results 1 to 8 of 8

Average # of Days (or Cells) in a Table

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2015
    Location
    Florida
    MS-Off Ver
    O365
    Posts
    61

    Average # of Days (or Cells) in a Table

    Good Morning Experts! Hoping someone can point me in the right direction. I have a schedule with Start and End dates and "x" or "h" to indicate if someone is on call for that week. Using a random name generator to mix up the names, but I want to make sure everyone has about the same amount of time between duty weeks. Looking for a way to easily see the average, number of days between each on call week. That way I can look and say Joe averages on call about every 6 weeks. Hope this kind of makes sense. Open to any ideas (formual, pivot, macro, etc)....Sample attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] i need to Calculate the average days the tickets have been open in the past 30 days
    By Reece_Norman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2022, 12:48 PM
  2. [SOLVED] Average over last 120 days with blank cells
    By KrystyneT in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2020, 12:50 PM
  3. Average no. of days if other cells meet multiple criteria
    By Elderlyoutlaw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-16-2019, 04:01 PM
  4. Replies: 2
    Last Post: 04-17-2018, 09:45 PM
  5. Replies: 7
    Last Post: 05-04-2017, 10:53 AM
  6. Replies: 7
    Last Post: 11-29-2016, 07:12 AM
  7. Replies: 13
    Last Post: 09-22-2016, 09:18 AM

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