google-sheetsschedulecountif

Scheduling: Counting the number of times a name is present based on the current date

I have a full year of individual dates listed chronologically from A3:A367. In B3:B367, I have names of staff members. This is a yearly schedule. I need to know the count of a each staff member's name based on the current date. Example below.

enter image description here

I understand how to do a YTD count using this formula in a different tab, but need to know the count based on the current date:

=COUNTIF('Current Schedule'!B3:B367,A4)

Thank you,

Tried using the word TODAY in the formulas...

Solution 
  • =countifs('Current Schedule'!A$3:A$367,"<="&today(),'Current Schedule'!B$3:B$367,A3)