You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers spreadsheet - Today's date update

Hi - I wonder if the forum could answer this simple question. I have successfully used some kind of action in the past to automatically update the Date in a cell within a Numbers spreadsheet to Today's date. In other words, every day, this cell shows the correct date without any intervention from me. But it was so long ago that I do not remember how I did it. Searching through the Help menu and other menus, it is not clear how this is done. Reading comments on Google, it is still not clear how to do it. Right clicking on the existing cell does not reveal how I did it. One would have thought that this is fairly basic functionality in any spreadsheet. Can you tell me how to do it please ? Thanks in advance.

iMac (21.5-inch, Late 2013), macOS Sierra (10.12.5)

Posted on Aug 12, 2018 2:14 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 12, 2018 2:36 AM

Hi Doctor Zhivago,


The TODAY function will update automatically when you open a document or edit an already-open document after midnight.

User uploaded file

(12 August 2018 in my Region)

You can format TODAY by clicking on the cell and Format Panel > Cell > Data Format > Date & Time.

User uploaded file

I included the NOW function to show how that updates the time from 7:24 pm to 7:27 pm) whenever you make a change to the table.


By the way, TODAY and NOW are virtually the same function (from the system clock) and both can be formatted to show/hide the date/time.


Or, are you looking for this under the Insert Menu into a sheet Header or Footer in Print Setup?

User uploaded file

You must manually Set to Today.


Regards,

Ian.

Similar questions

1 reply
Question marked as Top-ranking reply

Aug 12, 2018 2:36 AM in response to Doctor Zhivago

Hi Doctor Zhivago,


The TODAY function will update automatically when you open a document or edit an already-open document after midnight.

User uploaded file

(12 August 2018 in my Region)

You can format TODAY by clicking on the cell and Format Panel > Cell > Data Format > Date & Time.

User uploaded file

I included the NOW function to show how that updates the time from 7:24 pm to 7:27 pm) whenever you make a change to the table.


By the way, TODAY and NOW are virtually the same function (from the system clock) and both can be formatted to show/hide the date/time.


Or, are you looking for this under the Insert Menu into a sheet Header or Footer in Print Setup?

User uploaded file

You must manually Set to Today.


Regards,

Ian.

Numbers spreadsheet - Today's date update

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