+ Reply to Thread
Results 1 to 2 of 2

looking for a daily average based on the day of the month

  1. #1
    Registered User
    Join Date
    03-02-2014
    Location
    Louisville
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question looking for a daily average based on the day of the month

    I'm pulling my hair out trying to figure this one out.

    I am performing a given exercise every day in the month of march. I have the dates all lined up in my spreadsheet, with the sum at the bottom. What I want to do is have another cell that will give me my daily average of performance. For example today is the 2nd and I have performed this exercise 360 times, making my daily average 130 per day. If I performed 200 of the exercise tomorrow I would have a grand total of 560 repetitions making my daily average roughly 186 per day (the day, march 3 divided by the number of repetitions, 560) and so on and forth.

    I need a formula that will automatically calculate that daily average as I progress with the month. But I want the calculation to stop at the end (i.e. I don't want it to continue as the year progresses, meaning the divisor keeps going throughout the rest of the year). Basically, I guess, I am looking to fill in the daily repetition and the divisor to increase each day as I do so. My average is to be displayed in cell B36, so today my formula should read (=2/B36) and on March 31st the formula would be (=31/B36).

    I hope I have explained this well enough. I am an excel novice and am amazed by the power of this program. There is surely a formula out there for me.

    Thanks to everyone for reading.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: looking for a daily average based on the day of the month

    I assume B36 is the total count of reps for the month to date.

    Try this for the daily average:

    =B36/IF(TODAY()>DATE(2014,3,31),31,DAY(NOW()))

    It will stop at 3/31/2014.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Average daily data by month
    By aussie_sox in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2015, 12:48 PM
  2. Need to Average highest continuous 30 daily values over past 48 month span
    By BillGlass in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-29-2013, 09:39 AM
  3. Average and Median by week and month from daily data
    By jjj444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2013, 11:01 PM
  4. Replies: 1
    Last Post: 01-29-2013, 06:27 PM
  5. Average daily spending over month
    By deanseifert in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2011, 11:08 AM

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