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

1. ## 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,

2. ## 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. ## 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

4. ## 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. ## Re: Need Formula to make expenses report to the week by date entered

You are very welcome.

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