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.