+ Reply to Thread
Results 1 to 5 of 5

Need Formula to make expenses report to the week by date entered

  1. #1
    Registered User
    Join Date
    11-12-2016
    Location
    Casselberry, Florida
    MS-Off Ver
    2003
    Posts
    2

    Need Formula to make expenses report to the week by date entered

    Hello,

    I'm a new member to this forum. I am in need of some help with a formula to use dates to put amounts in different columns of my budget.

    I believe the budget should be pretty self explanatory, but I will explain some.
    I have made a expense tracker that when information is entered populates the monthly budget chart. Now I am trying to have it also populate the 4 separate weekly budget charts.

    In my attachment I have entered some random information showing how it populates each week with the same information.

    this is a link to where I found some possible information that might help but I don't know if it would work.
    http://www.excel-university.com/exce...nthly-columns/

    I have attached my budget sheet to this post.
    It is not fully complete as there will be other pages but I am struggling with this problem.

    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need Formula to make expenses report to the week by date entered

    Just to be clear:

    the data in row 39 down is allocated to the approprate category and week i.e. date between start/end week dates in "Soft total"?

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need Formula to make expenses report to the week by date entered

    Try

    C17

    =SUMIFS($A$39:$A$215,$C$39:$C$215,$A17,$B$39:$B$215,">=" & B$15,$B$39:$B$215,"<=" & C$15)

    Drag down column

    Copy/paste to other weeks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-12-2016
    Location
    Casselberry, Florida
    MS-Off Ver
    2003
    Posts
    2

    Re: Need Formula to make expenses report to the week by date entered

    Thank you very much for the quick response.

    it seems to be working perfectly.

    Again thank you.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need Formula to make expenses report to the week by date entered

    You are very welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Formula for week to date chart, but not showing until data entered.
    By paul*r in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2014, 01:41 PM
  2. Formula to show current week expenses on a different sheet
    By wiljar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 04:25 AM
  3. [SOLVED] Calculating a week of dates/days based on the beginning date entered...
    By tiffany04530 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-27-2012, 09:55 AM
  4. Replies: 0
    Last Post: 01-19-2012, 06:11 PM
  5. Make date entered in an InputBox UK format
    By Co-op Bank in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2006, 11:20 AM
  6. How can I set up week to date report?
    By Liz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2006, 03:10 PM
  7. Replies: 9
    Last Post: 12-27-2005, 02:50 AM

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