Count word in row to a particular date

Hi

I have a query. I have a badge scan file as attached. The badges numbers in column D will get scanned daily. I'm stuck in Row 5 where I need a count function to count the number of damaged cards in column A, as I scan each day. The problem is the card's status can get changed on any given day within the month Eg: from Damaged to Loan or Assigned. which I why I need a function to count on that current date.