Excel find earliest date within 12 month period.

I have an employee attendance calendar that I’m trying to create. When an employee is tardy or absent, they receive one occurrence. What I would like excel to do is (within a specific range) find the earliest date with the previous 12 month period. This date will reflect when the next occurrence will drop off. Hope this doesn’t sound confusing.


MODERATOR's EDIT: This thread has been moved to the correct forum.