Ask Your Question
1

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

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

this post is marked as community wiki

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

2 Answers

Sort by » oldest newest most voted
2

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

this post is marked as community wiki

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 more
0

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

this post is marked as community wiki

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 more

Comments

Search tab in the help for: number formats;codes

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

Thanks, mariosv

jobertel gravatar imagejobertel ( 2012-09-04 14:54:49 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2012-03-02 20:06:37 +0200

Seen: 263 times

Last updated: Aug 23 '12