Jump to content
Toggle sidebar
The Document Foundation Wiki
Search
English
Personal tools
Create account
Log in
Navigation
Main page
Get Involved
Recent changes
Random page
Support LibreOffice!
Editing the wiki
Help resources
Tools
What links here
Related changes
Special pages
Printable version
Permanent link
Page information
In other languages
Add languages
Translations
:
Faq/Calc/139/6/en
Translation unit
Discussion
English
Read
View source
View history
More
Read
View source
View history
From The Document Foundation Wiki
Dropdown list
Select the cell or range of cells concerned and go to
Data
▸
Validity
On the
Criteria
tab, and the
Allow
listbox, choose
Cell Range
In the
Source
box, type
TEXT(TODAY();"JJ/MM/AA")