Question regarding Month() Function

[jduenyas]

Hi all

in the Help section the description of the Month() function says as follows:

Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.

Example:
month( '1971-10-30' ) returns Oct.

(Worth noting that the functions Year() and Day() return integer and not text)

However, in the Edit Script section, when building a calendar and using the Month() function it returns an integer 1, 2, 3, ...

Why is the difference and how can I get the numerical value of the Month(Today()) or Month(Now())?

Thanks

[#2 · Accepted solution]

Write your formula like the following:

=num(month(now()))

This will return the numerical version of the month.

Stan

[jduenyas]

Thanks.

That did the trick!