Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

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

Top-ranking reply

Yellowbox

Level 7

21,301 points

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.

(12 August 2018 in my Region)

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

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?

You must manually Set to Today.

Regards,

Ian.

View in context

Numbers spreadsheet - Today's date update

Similar questions