I Number, Automatic Date

Hi🙂

is there any possibility for automatic dates in Numbers?

so the date of today will show up automatically when open the sheet?

Thank you,

Claudia

MacBook Pro, OS X Mavericks (10.9.1)

Posted on Aug 11, 2018 8:29 PM

Similar questions

Numbers invoice that is dated when it is created. Hi I have a numbers template for creating an invoice. It is dated and I would like to use a function so that when I select a new invoice it opens with the date on it. If I use the 'today' function, then the date changes if I open the spreadsheet on a different day. How can I get the date to stay the same as the date that I created the invoice?
701 2
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.
14151 1
How do I insert current date in a cell How do I insert the Current date into a cell
1041 4

2 replies

Badunit

Level 7

30,348 points

Aug 11, 2018 9:32 PM in response to claudiawats

The formula =TODAY() in a cell will give you today's date when you open the document. It will update whenever you make a change to a table or open the document again.

=NOW will give you date and time. It also updates when you make changes to a table.

claudiawats Author

Level 1

11 points

Aug 11, 2018 10:18 PM in response to Badunit

Thank you Badunit

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

I Number, Automatic Date

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