[Solved] Converting date serial number to date format

[ahughes]

I cannot find a function that will convert a date serial number to a conventional date format. I realize that I can construct such a function using the day(), month() and year() functions, but is there really no function built into Calc to do this?

While I haven't found such a function, I have found the method. You simply change the cell format from numeric to date and specify the format. Calc then does the rest.

I'm still curious if there is such a function however.

[eremmel]

In calc a date (with time) is just a number. The number is the offset of days since a predefined date (see options).
You give the meaning of a number as a date by giving it's format (press Ctrl-1 to format).

The difficult thing is that a number can be a number, a date/time or a duration (a date/time offset, or the difference between two dates). The latter can only be expressed in days, hours, minutes, ...

[acknak]

I cannot find a function ...
change the cell format from numeric to date and specify the format. ...

TEXT() converts a value to text according to a format string, same as the cell format.

With a date value in A1,

=TEXT(A1;"YYYY-MM-DD")

[ahughes]

Thanks, acknak. That's what I was looking for.