Formulas and Functions
ह्या कंट्रोलमध्ये बदल केल्यामुळे हे पेज ऑटोमॅटिकली अपडेट होईल

EOMONTH

The EOMONTH function returns a date/time value that is the last day of the month, some number of months before or after a given date.

EOMONTH(start-date, month-offset)

start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.

month-offset: The number of months before or after the starting date. month-offset is a number value. A negative month-offset is used to specify a number of months before the starting date and a positive month-offset is used to specify a number of months after the starting date.

Examples

=EOMONTH("15/5/2010",5) returns 31 Oct 2010, the last day of the month five months after May 2010.

=EOMONTH("15/5/2010",-5) returns 31 Dec 2009, the last day of the month five months before May 2010.

See alsoEDATE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.