count a range of cells (within another range of cells) based on today's date

I want to count how many times a particular name from column D appears within the range specified by today's date.

For example..today is Feb 6th, so I only want the range L3:M21 counted.

As you can see, Jose M is listed 2x. That tells me I have doubled booked him. I'm going to conditionally format column D based on this countif formula I can't fig out.

Thanks.



excel image.JPG

Try OFFSET + MATCH, perhaps? Something like (in E3):

=COUNTIF(OFFSET($F$3:$F$21,0,MATCH(TODAY(),$F$2:$Z$2,0)-1),$D3)

Adjust the size of the ranges to suit your workbook. Your original post said you wanted to count in L3:M21, but M is blank, so I presumed that was a typo? If it's not, you can include two columns in the count using:

=COUNTIF(OFFSET($F$3:$F$21,0,MATCH(TODAY(),$F$2:$Z$2,0)-1,,2),$D3)

CAntosh -

THX!
Now I just need to get it to work in google sheets.

Glad I could help! I don't have enough experience with Google Sheets to be much help with the next step, but my understanding is that most Excel Formulas transfer over cleanly. Good luck!