What is the equivalent of the DATEINFO function in Lotus 123?

English
,
#1

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.

#2

The TEXT(value;format) do the job, see the format values in the help.

#3

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.

#4

Search tab in the help for: number formats;codes

#5

Thanks, mariosv

#6

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.