Formulas and Functions

Chapter 3 Date and Time Functions 43
Function Description
“EDATE” (page 50) The EDATE function returns a date that is some
number of months before or after a given date.
“EOMONTH” (page 51 ) The EOMONTH function returns a date that is the
last day of the month some number of months
before or after a given date.
“HOUR” (page 51 ) The HOUR function returns the hour for a given
date/time value.
“MINUTE” (page 52) The MINUTE function returns the minutes for a
given date/time value.
“MONTH” (page 53) The MONTH function returns the month for a
given date/time value.
“MONTHNAME” (page 54) The MONTHNAME function returns the name of
the month from a number. Month 1 is January.
“NETWORKDAYS” (page 54) The NETWORKDAYS function returns the number
of working days between two dates. Working
days exclude weekends and any other specied
dates.
“NOW” (page 55) The NOW function returns the current date/time
value from the system clock.
“SECOND” (page 56) The SECOND function returns the seconds for a
given date/time value.
“TIME” (page 56) The TIME function converts separate values for
hours, minutes, and seconds into a date/time
value.
“TIMEVALUE” (page 57) The TIMEVALUE function returns the time as a
decimal fraction of a 24-hour day from a given
date/time value or from a text string.
“TODAY” (page 58) The TODAY function returns the current system
date. The time is set to 12:00 a.m.