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.