Results 1 to 3 of 3

Clock/Date Equation to Account for Each New Passing Months Cell Budget Totals

Threaded View

garrett.grillo Clock/Date Equation to... 01-15-2013, 08:44 PM
DBY Re: Clock/Date Equation to... 01-16-2013, 12:42 PM
garrett.grillo Re: Clock/Date Equation to... 01-16-2013, 01:01 PM
  1. #1
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel Professional Plus 2016
    Posts
    194

    Clock/Date Equation to Account for Each New Passing Months Cell Budget Totals

    I update budgets on my project on a monthly basis and I always have to go into the total column, “1st Qtr. Total (YTD)” and manually change and update the equations in these cell columns to include the beginning of each month’s new budget totals.

    Can someone help me with an equation that would automatically check the computer systems clock and when the next new month’s starts it would automatically add in that new month’s budget into the, “1st Qtr. Total (YTD)” column.

    So for example, the total column, “1st Qtr. Total (YTD)” automated equation I’m looking for would only total cell contents under “Jan-13”, but would not include the cell contents under “Feb-13” and “Mar-13”. However when were actually in the month of February 2013 this automated equation located in the total column, “1st Qtr. Total (YTD)” would then include the cell contents under both “Jan-13” and “Feb-13”, but exclude the cell contents under “Mar-13”.

    Please see the attached example, “Budget Example” for additional information and help.

    Thank You.

    Garrett
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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