Excel- count cells with date within the last year

Hi,    I have a database where we record compliance for training. To be compliant the date they completed the course must be within the last year, after the year they are non compliant again.    ...