Handy #LibreOffice Calc tip! Press Ctrl+; to insert the current date, or Shift+Ctrl+; for the current time. Want a date and time that's always updating? Use the =NOW() function. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060102.html #foss #opensource
@libreoffice : but wouldn't the time change the next time the workbook is opened/refreshed?
Need static data, not dynamic data...
@mars1024 @libreoffice
If I'm reading it correctly, the keypresses insert a static date / time, the function is dynamic.
So you should be able to subtract them and show "this document is x days old".