Mar 31 2019 11:24 PM
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.
Any ideas?
Date | Day of Week | Hours |
01/03/2019 | Thursday | 8.00 |
01/04/2019 | Friday | 8.00 |
01/14/2019 | Monday | 8.00 |
01/15/2019 | Tuesday | 8.00 |
01/21/2019 | Monday | 8.00 |
02/04/2019 | Monday | 8.00 |
02/05/2019 | Tuesday | 8.00 |
02/06/2019 | Wednesday | 2.50 |
02/18/2019 | Monday | 8.00 |
02/19/2019 | Tuesday | 8.00 |
02/21/2019 | Thursday | 8.00 |
03/11/2019 | Monday | 8.00 |
03/12/2019 | Tuesday | 8.00 |
03/13/2019 | Wednesday | 8.00 |
03/15/2019 | Friday | 8.00 |
03/22/2019 | Friday | 8.00 |
03/25/2019 | Monday | 8.00 |
03/26/2019 | Tuesday | 8.00 |
03/27/2019 | Wednesday | 8.00 |
Apr 01 2019 12:03 AM