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.

User profile for user: Darcy Phillips1
Darcy Phillips1 Author
User level: Level 1
63 points

Today formula function won't update automatically

I have a numbers document created on my mac. Every time I open it, I want the cell with the "today" function to reflect today's date. But it doesn't, it reflects the date when I last opened the document (and corrected it by deleting the today function, closing the cell, reopening the cell, and re- adding the today function, quite inconvenient. First world problems....)


How can I have the cell automatically look up today's date every time i open the document? thanks!

Posted on Jun 8, 2022 1:11 PM

Reply
Question marked as Top-ranking reply
User profile for user: Ralf-F
Ralf-F
User level: Level 4
2,717 points

Posted on Jun 8, 2022 1:39 PM

You could use NOW, this will update as soon as you open the file and as soon as you change something.

NOW will give you date and time, you can pick a format that will only show date.


Hope this will help


Ralf

View in context

Similar questions

3 replies

Today formula function won't update automatically

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