Hi everyone,

I’m stumped on an Excel formula here. I have a data set that shows each time we have serviced multiple properties. The expectation is that we service once per week on average (7 calendar days). I’m trying to find out how many services have we essentially missed if we did not service every 7 days.

For example, see Property ID: 11111111. Our first service was on 4/24 and our last service was 6/14. In total, we’ve serviced this property 4 times over the course of 51 days. Following the “every 7 day” rule, we should have serviced over 7 times (51/7) for a total of 3 missed services. 

I would need the missed services broken down by month, if possible, and for each client (column D).

​Hi everyone, I’m stumped on an Excel formula here. I have a data set that shows each time we have serviced multiple properties. The expectation is that we service once per week on average (7 calendar days). I’m trying to find out how many services have we essentially missed if we did not service every 7 days. For example, see Property ID: 11111111. Our first service was on 4/24 and our last service was 6/14. In total, we’ve serviced this property 4 times over the course of 51 days. Following the “every 7 day” rule, we should have serviced over 7 times (51/7) for a total of 3 missed services.  I would need the missed services broken down by month, if possible, and for each client (column D).  Read More

​