+ Reply to Thread
Results 1 to 2 of 2

Averageing both witing a month and weekday

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2013
    Posts
    79

    Averageing both witing a month and weekday

    Hello. I have searched everywhere and tried everything I know but cant seem to get this.

    I have daily data over many years. I would like to average the all of one weekday in the same month. For example, All Mondays in November over the course of many years.

    It is laid out like this:

    ...A............B.............C...................... BR..............BS
    1 DATE.......11/02/09...11/03/09.............02/14/16.....02/15/16
    2 VALUE......2.97.........3.45...................4.9.............1.9

    So using the date row I would like to average the Value row for specific days in specific months.

    Thanks so much!!!!!!!!!!!!


    EDIT: I APOLOGIZE FOR MY LAZINESS TO NOT CORRECT SPELLING IN THE THREAD TITLE. I WOULD EDIT OR DELETE AND RE-POST IF I COULD
    Last edited by Brennen81; 01-21-2017 at 01:10 PM.

  2. #2
    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: Averageing both witing a month and weekday

    Hi,

    There's no doubt an array formula for this but personally I'd transpose the data into a table, add a couple of helper columns for Day and Month, then Insert a Pivot Table with Slicers for Day and Month. Job done without all the head scratching over complex array formulae.

    See attached
    Attached Files Attached Files
    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.

+ 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] how to calculate the weekday from day of the month
    By John19 in forum Excel General
    Replies: 9
    Last Post: 07-12-2015, 05:17 AM
  2. Formula to find first weekday in month
    By leleco in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2014, 03:01 PM
  3. [SOLVED] FIrst Weekday of the month
    By astrikor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-04-2013, 09:28 AM
  4. Dynamic nth Day of Weekday-Next Month
    By nms2130 in forum Excel General
    Replies: 2
    Last Post: 06-29-2010, 09:56 AM
  5. [SOLVED] Weekday formula calculating to end of month
    By DebbieK in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-26-2006, 05:40 PM
  6. [SOLVED] nth weekday of the the month date problem
    By Thrashman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2006, 03:15 PM
  7. [SOLVED] Xth Weekday of the Month/Year
    By ZuludogM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2005, 07:05 PM

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