[users] Re: Calc -- monthname() function

[Joe Smith]

Kenn Goutal wrote:

It appears that, in my version at least,
there is no function that, given a number 1..12,
returns the name of the corresponding month.
...

You can always use something like this:

=TEXT("2001-" & MonthNumber & "-01"; "MMMM")

Works the other direction too:

=VALUE(TEXT(MonthName & " 1, 2001"; "M"))

<Joe


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]