Level 8 Level 10
Level 9

Date and time functions


22 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
DATE
Returns the serial number of a particular date
DATEVALUE
Converts a date in the form of text to a serial number
DAY
Converts a serial number to a day of the month
DAYS360
Calculates the number of days between two dates based on a 360-day year
EDATE
Returns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months
HOUR
Converts a serial number to an hour
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
NETWORKDAYS.INTL
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
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
Converts a serial number to a number representing where the week falls numerically with a year
WORKDAY
Returns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
YEAR
Converts a serial number to a year
YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date