From The Document Foundation Wiki
How to insert a variable date into a cell
Insert a function into the cell, following these instructions:
- Select the desired cell.
- Go to ▸ .
- In the Categories list, choose Date and time.
- Click on TODAY to get the current date or NOW if you also want to write the hour.
- Click on Next.
- Click on OK.