Hello all!
I am making an attendance tracker that counts the occurrences (entered by date) and would like the "current count" to reset every 6 months, starting with the first entry in cell A11. Below is the formula I am using in cell B7 - however I would like the count to reset 6 months after 1/1/18. So, the current count would read 3, even though there are 4 entries.
Any help or suggestion to make this easier would be greatly appreciated! Thank you!
<tbody>
</tbody>
I am making an attendance tracker that counts the occurrences (entered by date) and would like the "current count" to reset every 6 months, starting with the first entry in cell A11. Below is the formula I am using in cell B7 - however I would like the count to reset 6 months after 1/1/18. So, the current count would read 3, even though there are 4 entries.
Any help or suggestion to make this easier would be greatly appreciated! Thank you!
=COUNTIF(A11:A72,"<"&EDATE(TODAY(),6)) | |||||
current count--> | 4 | ||||
11 | 1/1/18 | ||||
12 | 2/1/18 | ||||
13 | 3/1/18 | ||||
14 | 11/1/18 | ||||
<tbody>
</tbody>