It really isn't running that far, but I need help with figuring a running average for the last 30 days, 3 months, 6 months, and year from today's date. I have been trying to use an averageif function, but it doesn't quite work the way I want it to. I have a due date and a delivered date which calculate if it is early or late to the client. I am trying to find an average based on a certain employee of how late or early they are to clients. for example.
Col a b c d
1 due del early/late employee
2 5/11 5/12 1 day late john
3 5/22 5/21 1 day early jeff
4 6/1 5/27 2 days early john
5 6/6 6/8 2 days late jeff
etc.
I need the average of column c for a specific employee in column D for the past 30 days/3 mo/6 mo/1 year based off of column b. the newest data continues to be added after the last row of data and continues for hundreds of rows.
Am I missing some simple formula that could easily figure this out?
Col a b c d
1 due del early/late employee
2 5/11 5/12 1 day late john
3 5/22 5/21 1 day early jeff
4 6/1 5/27 2 days early john
5 6/6 6/8 2 days late jeff
etc.
I need the average of column c for a specific employee in column D for the past 30 days/3 mo/6 mo/1 year based off of column b. the newest data continues to be added after the last row of data and continues for hundreds of rows.
Am I missing some simple formula that could easily figure this out?
Last edited:
