What is the equivalent of the DATEINFO function in Lotus 123? [closed]

calc
date

asked 2012-03-02 20:06:37 +0100

This post is a wiki. Anyone with karma >75 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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 20:20:12.207593

add a comment

2

answered 2012-03-03 00:41:42 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit flag offensive delete link

add a comment

0

answered 2012-08-23 19:40:10 +0100

This post is a wiki. Anyone with karma >75 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.

edit flag offensive delete link

Comments

Search tab in the help for: number formats;codes

m.a.riosv ( 2012-08-24 01:06:09 +0100 )edit

Thanks, mariosv

jobertel ( 2012-09-04 14:54:49 +0100 )edit

add a comment

What is the equivalent of the DATEINFO function in Lotus 123? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 20:20:12.207593

2 Answers

Comments

Question Tools

Stats

Related questions

What is the equivalent of the DATEINFO function in Lotus 123? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-17 20:20:12.207593

2 Answers

Comments

Question Tools

Stats

Related questions

What is the equivalent of the DATEINFO function in Lotus 123? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 20:20:12.207593