[SOLVED] How to copy-paste the result of =TODAY() as a date?

[raschumacher]

Is there a way to copy from a cell which contains the formula =TODAY() and paste only the value (that is, date) of that formula into another cell? None of the "Paste Special" options and none of the combinations of options that I have tried works; the "Number" option, both by itself and with the "Format" option, does paste the date number, but not in date format.

As a workaround, is there an inverse function of DATEVALUE("text") ? That is, a function which converts a date number into a date?

[Zizi64]

The LibreOffice Calc has "insert fixed date" feature.

Or you can cut (Ctrl-X), and then Paste special/Unformatted text (Shift-Ctrl-V) the date value created by the Today() function.

[RusselB]

The Paste Special with the number option checked will paste a static number that can be formatted using the Format Cells (Ctrl+1) options, so that you see the date in the format that you want.
If you have the cells already formatted as you want the display, leave the format option unchecked, that way the format used will be the format already applied to the cell.
There is no reverse for the DATEVALUE function in Calc, unless you want to write a macro that performs that job.

[raschumacher]

Thanks. Pre-formatting the target cell, or changing the format after pasting the value (the date number), does indeed work.
It seems to me a bug that the date format cannot be special-pasted along with the value, but oh well :_>

[Villeroy]

Paste special "Date+Time" and "Formatting" works with LibreOffice 6.1

[MrProgrammer]

As a workaround, is there an inverse function of DATEVALUE("text") ? That is, a function which converts a date number into a date?

Read section 3. Dates in cells in Ten concepts that every Calc user should know. A date number IS a date. You need to make your goal clear.

If you want the cell's value to be the numeric date but you want the cell to display the year/month/day instead of the number, read section 2. Controlling how data is displayed in the tutorial. Use the Date category and select the format. Use the General category to format the cell.

If you want the cell's value to be text instead of a number, use the TEXT function.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[raschumacher]

The exact thing required is: Copy -> Paste Special -> select "Date & Time" & "Formats". Then the date number is pasted with the source format. My bad. Thanks all for the help.