Running averages based on a DATE

Hi

I wish to calculate a running average of one criteria against multiple other criteria - %WFH against different types of attendance at work). This is calculated in the red table in the attached example. The averages are Col S (%WFH 1 against certain attendances) and Col U % WFH 2 against all attendances. These records are averaging since 01.1.2022. I want to add a DATE criteria that only counts the running average up to TODAYs date (i.e. it is not counting attendances rostered into the future). I would also like to understand how to include a date criteria if I want to limit the average to a specific time period e.g. just a calendar month, a specified date range (e.g. 10 May 24 June)
I hope my query is comprehensible and thank you in advance for any advice/assistance

Hi 6StringJazzer

I don't want a separate average particularly, and I wouldn't modify the calculations in C,E,I and J. I want this average to run all the time based on WFH being the sum of the contents of Cells C,E, I and J for each row. I just don't want them to count anything in the future (as in events rostered after TODAY). If I look at an average today I want the average to be based only on events that have already happened.

I will create a separate table using begindate and enddate, when I get my head around my first conudrum!

I tried the first solution but I have made it work yet....

Well that very much looks like modifying C, E, I, J is the way to go. But what modifications??

Hi there, thanks a million for the tutoring! I really understand this now. One strange thing when I did it on a trial sheet, it worked fine. But when I am populating it in a real sheet, the totals in the table are not adding up to the correct amount. E.g. say John in cell B2. When I select he total number of days leave for him to date, the number is 4 with 2 days due in June therefore totalling 6. But the cell is counting it as 23. Could I ask you to take a look and see where I have gone wrong? Please?

Thank you so much for your help. I learnt a lot from you and always try to put into practice whatever the excel lords impart....