Functions and Macros

FUNCTION | DESCRIPTION | DAVERAGE | Returns the average of selected database entries | DCOUNT | Counts the cells that contain numbers in a database | DCOUNTA | Counts nonblank cells in a database | DGET | Extracts from a database a single record that matches the specified criteria | DMAX | Returns the maximum value from selected database entries | DMIN | Returns the minimum value from selected database entries | DPRODUCT | Multiplies the values in a particular field of records that match the criteria in a database | DSTDEV | Estimates the standard deviation based on a sample of selected database entries | DSTDEVP | Calculates the standard deviation based on the entire population of selected database entries | DSUM | Adds the numbers in the field column of records in the database that match the criteria | DVAR | Estimates variance based on a sample from selected database entries | DVARP | Calculates variance based on the entire population of selected database entries | TOP OF PAGE

Date and time functions FUNCTION | DESCRIPTION | 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 | 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