Microsoft Office Tutorials and References
In Depth Information
Calculates the number of days between two dates, based on a
360-day year.
DAYS360
Returns the serial number of the date that is the indicated number
of months before or after the start date.
EDATE
Returns the serial number of the last day of the month before or
after a specified number of months.
EOMONTH
HOUR
Converts a serial number to an hour.
Returns the number of the ISO week number of the year for a giv-
en date.
ISOWEEKNUM**
MINUTE
Converts a serial number to a minute.
MONTH
Converts a serial number to a month.
NETWORKDAYS
Returns the number of whole workdays between two dates.
Returns the number of whole workdays between two dates (inter-
national version).
NETWORKDAYS.INTL*
NOW
Returns the serial number of the current date and time.
SECOND
Converts a serial number to a second.
TIME
Returns the serial number of a particular time.
TIMEVALUE
Converts a time in the form of text to a serial number.
TODAY
Returns the serial number of today's date.
WEEKDAY
Converts a serial number to a day of the week.
WEEKNUM
Returns the week number in the year.
Returns the serial number of the date before or after a specified
number of workdays.
WORKDAY
Returns the serial number of the date before or after a specified
number of workdays (International version).
WORKDAY.INTL*
YEAR
Converts a serial number to a year.
Returns the year fraction representing the number of whole days
between start_date and end_date.
YEARFRAC
Search JabSto ::




Custom Search