Count instances of value in table prior to date

Hi everyone, I'm trying to find a way to create a field that counts the # of times an email address exists within a table based on a date field within that record. Example: Record is created with a...