I'm trying to create a spreadsheet and nothing I try is working and I have been at this for days now.

I need to count how many times in the last 30 days an employee has worked more than 12 hours.

I have it so that A3:A308 are dates (3/1/2018 through 12/31/2018) and the employee names are listed in the first row (just to test it out I'm using B1 through P1). Row 2 is where i want to insert the formula.

So for B3 through B308, I will enter number of hours worked each of those days.

I want B2 to tell me how many times in the last 30 days based on TODAY's date and the dates in A3:A308 that the value in B was greater than or equal to 12.

HELP PLEASE!!