+ Reply to Thread
Results 1 to 2 of 2

Daily Budget Formula Needed

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    London, England
    MS-Off Ver
    Excel For Mac 09
    Posts
    1

    Daily Budget Formula Needed

    This is quite possibly a very simple question that I've spent so long looking at, have over confused myself. As such someone looking at it with a fresh set of eyes would really help!

    I update a budget sheet daily over the course of each month in which I have an total amount to stay within. Currently my daily budget is simply taken by dividing this total amount by the number of days in the month.

    For example...if my total budget is 5,000 then my daily budget in January (31 days) is about 161.29.

    However my ACTUAL spend each day will often be over or under this figure, so on the first day of the month I may spend 173.40 and on the second day I may spend 144.32 (completely random figures simply for demonstration).

    What I want is a formula within my daily budget column that will either add or subtract this over or underspend from the previous day to the daily budget, staying within my total budget for the month.

    So far my main problem has been creating a formula that does not affect other columns within the sheet such as the difference in spend from each day, and also provides me at the end of the month with figures that add up to my total amount.

    I hope this is explained clearly enough.

    Thanks!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Daily Budget Formula Needed

    Hi Sammir,


    Welcome to the forum.

    Please explain your query through a sample file. While replying, click on Go advanced and look for a paper clip icon to upload a sample file. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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