SUMIFS Date Ranges

[Bart60]

Original Message (reinstated by moderator):

Hi,

I need to get the totals for due dates within a week, 2 weeks, 3 weeks, and 4 weeks. This should be in reference to today's date but I'm not sure how to get the formulas.

This is on the Status sheet in cells E5:E8

Can someone please help?

I will put solution later

Thanks

[AliGW]

Thanks for letting us know it's solved. Please post the solution now before you forget.

Did you work it out yourself or get help elsewhere? If the latter, then you really need to read our rule on cross-posting (rule #3): https://www.excelforum.com/forum-rul...rum-rules.html

[Bart60]

I thought I had it but unfortunately I couldn't get it.

I reformatted with date ranges of today, 1 week, 2 weeks, and so on for the ages.

Could someone figure out the formulas for column I on the Status sheet?

Thank you

[Bob Phillips]

What is wrong with the formula that you have there already?

[Bart60]

I need the formulas in I1:I9 highlighted yellow please. These results should add up to the total outstanding amount.

[AliGW]

Please enter (manually calculated) results for the yellow cells so that we know what you think the outstanding amount should be.

[Bob Phillips]

The formula for today is

Please Login or Register  to view this content.

I am confused by the other dates though, the label says Due in 1 Week, the date formula shows a week ago. Which should it be?

Shouldn't you also have a cell for overdue dates?

[Bart60]

Thanks for help I put the amounts that should be in the yellow cells.

[Bob Phillips]

First one, today is

Please Login or Register  to view this content.

Second is

Please Login or Register  to view this content.

copied down to rest

[Bart60]

That is perfect thank you. I was having trouble getting the pattern.