Need Help with &Today() function

Hi All

I have summarized a personal finance Spreadsheet and I want to summarize some totals at the bottom of each month.

I have made a bit of a start with "Bills paid in the previous 7 days, to be paid Today, to be paid tomorrow etc.

Please can you help me find the right formula for the following summaries:

I Still need help with :
Bills to be paid this Week
Bills to be paid in the next 7 days
Bills to be paid between now and Pay day

When I say the next week I mean dynamically between now and the next up and coming Sunday
and when I say 7 days I mean dynamically for the next 7 days from when I am viewing the Spreadsheet.

Many thanks
A

I think this does what you want:

Bills to be paid in the next 7 days :

Formula:

Please Login or Register  to view this content.

Bills to be paid this week:

Formula:

Please Login or Register  to view this content.

Bills to be paid between now and Pay day: I didn't see the payday date on your spreadsheet but once you provided it the formula will be very similar to the "Bills to be paid in the next 7 days" formula.

Geoff