I have looked all over and cannot seem to find what I am looking for so hopefully this awesome community will be able to help.
I need to calculate the total # of times an event has happened over the last 4 weeks. For example, I have a chart of time off (vacation, sick, personal, etc) with the date/day of week/hours taken (see below) and need to be able to keep a count of total # of events that have happened in the previous 4 weeks (just number of events, does not matter the amount of hours for each event). Right now I basically have to open the calendar and count back 4 weeks from today and then count all the events that occur between those two dates. I would love a way to have a running total on any given day. In the chart below you can see in the last 4 weeks the total count is at 8 so if I was to add an additional event on 04/05/19 it would tell me 9 instances have happened. But then if I add another instance on 04/11/19 it would then be at 7 instances for the last 4 weeks.