Well I have learned enough to be really dangerous, but still not enough to do this one properly. I got a suggestion on this from someone here but it still doesn't do what I need it to do. I have a column of counters that are collected at least once a week from a machine. The counters are not checked every day and when they are, it's not always the same day. But at least once a week. I need the adjacent column to look and see when the last instance of counter was recorded and subtract this day from that getting the difference between the 2. It was suggested to use an IF AND statement but that only went back a few days. I tried editing the formula but realized I can only nest 7 statements. So began looking at alternatives but so far haven't figured it out.
thanks in advance for all your suggestions and help.
counter formula testing.xlsx
Bookmarks