Running monthly totals based off a weekly adding

Any help would be greatly appreciated on this task! On the sheet named "TSA Dashboard" I have a weekly view, a monthly view & a break down of the associates work in the weekly view. What I want is for the dates in the weekly view to be based off the actual date (=NOW() - WEEKDAY(NOW(),3)-4), my current formula to show Thursday - Wednesday.

In the breakdown part, we put our stats that we enter manually and then over to the side of it, I have the MTD stats.

I would like for the MTD to add the totals throughout the month and clear at the end of the month. Please, if you have any ideas on how to make this work, I am all ears! If you want to create a new sheet to do vlookups based of a dates through out the year, be my guest! I am just trying to figure out how to get this done! I have attached exactly what I have now, if that may help!

your sample file does not have TSA daily only TSA Dashboard?

hmm first thing in C4

Formula:

Please Login or Register  to view this content.

then you have formula in C3 to strip the time out?
you could just use TODAY() instead of NOW()

Re
MTD
how/where is the data accumulating?
cant see anything on dashboard sheet that would indicate this