Formula to add timesheet entries to correct month

Hi all,
I’m not sure if this can be done at all but I’d like to work out a way to add timesheet entries to the appropriate month.

I currently receive timesheets with a week commencing date and then hours for Monday through to Sunday. I have defined which month each day of the week falls into with a formula - see screenshot:

I would now like to run a report that adds up all hours worked on any project and in any given month but I can only come up with a report that rolls up the totals in two columns which doesn’t help.

What I’ve got:
02

What I’d like to have:
01

Not sure if I’m just looking at this from the wrong angle but I can’t figure out any way to make this work and would appreciate any help on this.

Thanks a ton.

Hello,

I’ve read through your request and have a solution in mind. Would you be able to chat further via free phone consultation to discuss this project in detail so I can provide a price and turn around time?

Schedule a free phone consultation via this link: www.wisedesign.co/schedule

To learn a little more about myself, please visit my website: www.wisedesign.co

If you’d like to connect with me on LinkedIn, please do so here: https://www.linkedin.com/in/eckline/

I look forward to hearing form you!

Best,
Eric

Hi Eric,

Sure - are you available tomorrow for a call?

@nadja_stanglauer, I sure am! Please select a time that works best for you via this link: https://www.wisedesign.co/schedule/

Hi,
What you are wanting to achieve is definitely well within my area of expertise and I would be glad to help you out on it.
You can reach me on andrewjohnson56782@gmail.com
Best Wishes,
Andrew

Hi,

Please check PM.

Thanks,
Jennifer J