How to count the number of dates entered in a column using Numbers formula?

Hi there. I am wanting to create a formula that counts how many times I need to contact a client.


Every time I attempt to contact a client, I put the date in the ‘Last Attempted Contacted’. Is there a formula that will count how many times I enter a date in a cell? At the moment I manually fill it in, which isn’t working.


For example I would like column I to count how many times I make an entry into column G.



[Re-Titled by Moderator]

Original Title: Numbers Formula

iPad Pro, iPadOS 18

Posted on Dec 28, 2025 10:49 PM

Reply
2 replies

Dec 29, 2025 10:18 AM in response to HayleyHatzi

As described, the answer will always be 1.


It sounds like you're wanting your spreadsheet to count how many times the cell value was changed. It doesn't do that. When you change a cell value (e.g. set the 'last contacted' cell to today), all previous history of that cell is lost (other than via undo, which is inherently temporary).


The cell has no idea whether the current value is the first or thousandth value that's been entered.


The only ways to do what you describe is to either have a range of multiple cells with one date per cell (count the number of non-empty cells to see how many times you tried to contact them), or a separate cell that you manually increment each time you call.

How to count the number of dates entered in a column using Numbers formula?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.