| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count If value is greater than 12 and within the past 30 days
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!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if past today () - 30 days | Excel Worksheet Functions | |||
| Caluclating days past due | Excel Discussion (Misc queries) | |||
| Rolling date looking 30 Days past | Excel Worksheet Functions | |||
| Number of days past due | Excel Worksheet Functions | |||
| Count No of days past due | Excel Worksheet Functions | |||
Threaded Mode
