I have two Google Sheets workbooks, Workbook A and Workbook B.
Workbook A is generated from a Google form that collects email addresses submitted from users. Workbook A has two columns next to each other, one with a timestamp (formatted with date and time like this: 3/11/2019 8:16:51) and the other with the email address.
I want to count the number of days each email address has been submitted. I want to put that number in Workbook B.
So here is the formula I put in Workbook B (edited for privacy):
I was going to change the email and put that formula in a cell for each person whose response rate I wanted to count.
I have two questions:
First, that formula doesn't work at all. Can it be fixed?
Second, is there a better way, overall, to accomplish what I'm trying to do?