Good morning
I'm trying to create a COUNTIF statement that will count every time a string "ABS" appears in a date range. But I need the date range to roll based on today's date, so something like this = COUNTIF(TODAY()-365:TODAY(),"ABS"). I know the range is invalid, I'm not sure the proper syntax to make this work. So I have a column with all the dates listed (A4:A734), and a row with names (B1:GT1). I need a formula in each column to count every time ABS appears in that same column within a year from todays date.
I have attached the worksheet.Scheduling workbook.xlsx
Is there anyone out there who can please help me?
Bookmarks