Formula to add timesheet entries to correct month

1685 5
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

What I’d like to have:

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.

5 Replies 5
Not applicable


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:

To learn a little more about myself, please visit my website:

If you’d like to connect with me on LinkedIn, please do so here:

I look forward to hearing form you!


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:

8 - Airtable Astronomer
8 - Airtable Astronomer

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
Best Wishes,

4 - Data Explorer
4 - Data Explorer


Please check PM.

Jennifer J