We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

[LibreCalc] Adding date cell that is always up to date

asked 2021-05-04 13:26:11 +0200

Laniakea gravatar image


I'd like to have a cell in LibreOffice Calc that always displays the current date when the file is being opened.

Is that something that is possible? If so how would I do that?

Kind regards, Laniakea

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-05-04 13:47:03 +0200

Opaque gravatar image

updated 2021-05-04 14:00:32 +0200


=TODAY() (or =NOW() and using a proper format code [e.g.: YYYY-MM-DD HH:MM:SS], if you want a time as well).


[1] - LibreOffice Help - TODAY
[2] - LibreOffice Help - NOW

Hope that helps.

edit flag offensive delete link more


Please also note:
The functions TODAY() and NOW() are volatile. This means they will be recalcuölated (and the results updated) as often as any recalculation occurs.
The Date (or DateTiume) shown will therefore not indicate when the document was loaded, but when it was last recalculated. Details will depend on whether or not the AutoCalculate option was enabled.
If you definitely want to show the DateTime value for the event of "opening" you will need user code bound to the document event onViewCreated.

Lupp gravatar imageLupp ( 2021-05-04 16:55:48 +0200 )edit

Thanks, you're the best! That's exactly what I was looking for.

Laniakea gravatar imageLaniakea ( 2021-05-05 09:15:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-05-04 13:26:11 +0200

Seen: 36 times

Last updated: May 04