Count date occurrences in a comment cell

Raluca · Aug 11th 2021

I need to count how many calls are made each day based on that date occurrence in a cell with comments.

Is there a formula I could add in column E to show the results that I manually pasted please?

Or is there a way to count how many comments there are on a particular date?

Thank you!

**rory** · Aug 11th 2021

Assuming the date format is consistent, and you don't call more than once a day, you could use:

=COUNTIF(B:B,TEXT(D3,"\*dd/mm/yyyy\*"))

and copy it down.

Raluca · Aug 11th 2021

Thank you so much!

Participate now!