How to automatically update date in Numbers based on cell content change?

You're right. it is a simple one :)

=NOW()

NOW() returns the current date/time. It updates every time the file is opened, or any cell values are changed.

At least, it is a simple one if you want a global tracker. There's no facility to track edits on a specific cell (i.e. changing any cell will update NOW(), not just specific cells you want to 'watch').

Hi mjhaye,

Menu > Insert > Date & Time is not automatic. It requires an action by a human. It becomes a time stamp (time stamp is an often asked question in this forum).

Click twice in a cell and Menu > Insert > Date & Time.

Double click to format the Date & Time.

Unlike the NOW function, it does not change other cells (Table 1 B2 has not updated).

Thank goodness that we humans are still needed in spreadsheets!

Regards,

Ian.