EOMONTH

āĻŽāĻžāϏ⧇āϰ āĻļ⧇āώ āĻĻāĻŋāύ⧇āϰ āϤāĻžāϰāĻŋāĻ– āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰ⧇ āϝāĻž āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāĻ– āĻšāϤ⧇ āĻĻā§‚āϰāĻŦāĻ°ā§āϤāĻŋ āĻŽāĻžāϏ āĻ āĻĒāĻĄāĻŧ⧇āĨ¤

Syntax

EOMONTH(āĻļ⧁āϰāϰ āϤāĻžāϰāĻŋāĻ–; āĻŽāĻžāϏ)

āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāĻ– āĻšāϞ⧋ āϤāĻžāϰāĻŋāĻ– (āĻšāĻŋāϏāĻžāĻŦ āĻļ⧁āϰ⧁āϰ āĻŦāĻŋāĻ¨ā§āĻĻ⧁)āĨ¤

āĻŽāĻžāϏ āĻļ⧁āϰ⧁āϰ āϤāĻžāϰāĻŋāϖ⧇āϰ āĻĒā§‚āĻ°ā§āĻŦ⧇ (āύ⧇āϗ⧇āϟāĻŋāĻ­) āĻ…āĻĨāĻŦāĻž āĻĒāϰ⧇ (āĻĒāϜāĻŋāϟāĻŋāĻ­) āĻŽāĻžāϏ⧇āϰ āϏāĻ‚āĻ–ā§āϝāĻžāĨ¤

Example

āϏ⧇āĻĒā§āĻŸā§‡āĻŽā§āĻŦāϰ ā§§ā§Ē ⧍ā§Ļā§Ļā§§ āĻāϰ āĻĒāϰ⧇ ā§Ŧ āĻŽāĻžāϏ⧇āϰ āĻļ⧇āώ āĻĻāĻŋāύ āϕ⧋āύāϟāĻŋ?

=EOMONTH(DATE(2001;9;14);6) returns the serial number 37346. Formatted as a date, this is 2002-03-31.

=EOMONTH("2001-09-14";6) works as well. If the date is given as string, it has to be in ISO format.