asked 2012-03-02 20:06:37 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
In Calc is there a method to mimic the DATEINFO function in Lotus 123? This function yields, among other things, the alpha versions of month and day of the week of a date.
answered 2012-03-03 00:41:42 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
The TEXT(value;format) do the job, see the format values in the help.
answered 2012-08-23 19:40:10 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Thanks, I had to guess at the formats, but "MMM" yields the month, "DDD" the date, etc. I'll play with it some more.
The formats were not obvious in Oo.org either. Maybe include a link in the help to a format library if the formats are common to other functions.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-02 20:06:37 +0200
Seen: 74 times
Last updated: Aug 23 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
