Count date occurrences in a comment cell

  • 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.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why