Formulas and Functions

Chapter 3 Date and Time Functions 51
EOMONTH
The EOMONTH function returns a date that is the last day of the month some number
of months before or after a given date.
EOMONTH(start-date, month-oset)
 start-date: The starting date. start-date is a date/time value.
 month-oset:The number of months before or after the starting date. month-oset
is a number value. A negative month-oset is used to specify a number of months
before the starting date and a positive month-oset is used to specify a number of
months after the starting date.
Examples
=EOMONTH(”5/15/2010”, 5) returns Oct 31, 2010, the last day of the month ve months after May 2010.
=EOMONTH(”5/15/2010”, -5) returns Dec 31, 2009, the last day of the month ve months before May
2010.
Related Topics
For related functions and additional information, see:
“EDATE” on page 50
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
HOUR
The HOUR function returns the hour for a given date/time value.
HOUR(time)
 time: The time the function should use. time is a date/time value. The date portion
is ignored by this function.
Usage Notes
The hour returned is in 24-hour format (0 is midnight, 23 is 11:00 p.m.). Â
Examples
=HOUR(NOW()) returns the current hour of the day.
=HOUR(”4/6/88 11:59:22 AM”) returns 11.