Selecting data from a date range based on the current date

hello, I'm new to the forum and would be grateful if anyone could help with the problem.
I created a basic excel weekly budget and would like to know how much money I have as of todays date. on the top row I have a date range from Sunday to Saturday, so it looks like this:
09-15 16-22 23-29
with the month manually put in above it.
then below I have income and expenses with a Overall below that, so basically what I want to is see the Overall value based on todays date, not sure how to do this with the weekly range and automatic current date(which is =TODAY() as far as I know)

any help would be great. I have attached a photo as a reference.

Budget Picture.jpg

sorry about that, here you go

Budget.xlsx

the answer id like is the Total Overall, its separate from that sample you have posted. so like to the side id like it to say the date then below that the Total Overall. Then as the date will change each day as it does and passes to the next week, then id like the Total Overall to change to that weeks figure.
so say today is the 20-jun then the Total Overall would be £236, and as the date changes to the 23-june the Total Overall would automatically change to £226.

do you see what I mean ?

hey thank you so much for your help. ive opened the one you sent and there doesn't seem to be any difference from the one I sent you?

Sorry I still see no changes at all. there is now yellow also. what did you do and where ?

haha no problem, thanks you very much, I appreciate it