+ Reply to Thread
Results 1 to 2 of 2

Calculate Daily Goal to get to End of Month Goal

  1. #1
    Registered User
    Join Date
    05-31-2016
    Location
    Oregon, US
    MS-Off Ver
    2016
    Posts
    2

    Calculate Daily Goal to get to End of Month Goal

    d=daily goal
    t=total days
    r=remaining days
    m=Month to date average
    g=End of month goal

    I need the formula to get d.

    Example numbers
    t=17
    r=5
    m=19.25
    g=17.25

    What formula would I use to get the daily goal to reach the end of month goal.

    EDIT: Basically, the goal is to reach a lower number, the end of month is an average for each day in the month and I need a formula to calculate what I want to reach each day to get that goal.
    Last edited by budzique; 05-31-2016 at 05:56 PM. Reason: More information.

  2. #2
    Registered User
    Join Date
    05-31-2016
    Location
    Oregon, US
    MS-Off Ver
    2016
    Posts
    2

    Re: Calculate Daily Goal to get to End of Month Goal

    Pretty sure I got this.
    Please Login or Register  to view this content.

+ 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. Replies: 6
    Last Post: 06-01-2016, 02:23 PM
  2. Formula regarding daily goal calculation needed
    By LaserDance in forum Excel General
    Replies: 7
    Last Post: 01-20-2015, 07:46 PM
  3. [SOLVED] Seeking Goal without using Goal Seek
    By Doc Science in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2015, 02:24 PM
  4. [SOLVED] Daily AVG needed to reach monthly goal - Example Attached
    By rufus40444 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-20-2013, 02:47 PM
  5. Replies: 3
    Last Post: 07-27-2012, 01:44 PM
  6. Goal Seek VBA with relative 'Goal' parameter
    By alirulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2012, 07:19 PM
  7. Update daily goal
    By networx2002 in forum Excel General
    Replies: 5
    Last Post: 11-04-2010, 10:23 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