Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Category: Database Functions

Excel Database Functions perform basic calculations, such as sum, average, count, etc, They are designed to help you to work within a database.

DVARP function: Description, Usage, Syntax, Examples and Explanation

What is DVARP function in Excel? DVARP function is one of Database functions in Microsoft Excel that calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify. Syntax of DVARP function DVARP(database, field, criteria) The DVARP function syntax has the…

DVAR function: Description, Usage, Syntax, Examples and Explanation

What is DVAR function in Excel? DVAR function is one of Database functions in Microsoft Excel that estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify. Syntax of DVAR function DVAR(database, field, criteria) The DVAR function syntax has the…

DSTDEV function: Description, Usage, Syntax, Examples and Explanation

What is DSTDEV function in Excel? DSTDEV function is one of Database functions in Microsoft Excel that estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify. Syntax of DSTDEV function DSTDEV(database, field, criteria) The DSTDEV function syntax has…

DSUM function: Description, Usage, Syntax, Examples and Explanation

What is DSUM function in Excel? DSUM function is one of Database functions in Microsoft Excel that adds the numbers in a field (column) of records in a list or database that match conditions that you specify. Syntax of DSUM function DSUM(database, field, criteria) The DSUM function syntax has the following arguments: Database: The range of cells that makes up the…

DSTDEVP function: Description, Usage, Syntax, Examples and Explanation

What is DSTDEVP function in Excel? DSTDEVP function is one of Database functions in Microsoft Excel that calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify. Syntax of DSTDEVP function DSTDEVP(database, field, criteria) The DSTDEVP function syntax…

DAVERAGE function: Description, Usage, Syntax, Examples and Explanation

What is DAVERAGE function in Excel? DAVERAGE function is one of Database functions in Microsoft Excel that averages the values in a field (column) of records in a list or database that match conditions you specify. Syntax of DAVERAGE function DAVERAGE(database, field, criteria) The DAVERAGE function syntax has the following arguments: Database     is the range of cells that makes up the…

DPRODUCT function: Description, Usage, Syntax, Examples and Explanation

What is DPRODUCT function in Excel? DPRODUCT function is one of Database functions in Microsoft Excel that multiplies the values in a field (column) of records in a list or database that match conditions that you specify. Syntax of DPRODUCT function DPRODUCT(database, field, criteria) The DPRODUCT function syntax has the following arguments: Database: The range of cells that makes up the…

DMIN function: Description, Usage, Syntax, Examples and Explanation

What is DMIN function in Excel? DMIN function is one of Database functions in Microsoft Excel that returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify. Syntax of DMIN function DMIN(database, field, criteria) The DMIN function syntax has the following arguments: Database: The range of cells that makes up…

DCOUNTA function: Description, Usage, Syntax, Examples and Explanation

What is DCOUNTA function in Excel? DCOUNTA function is one of Database functions in Microsoft Excel that counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria. Syntax of DCOUNTA…

DMAX function: Description, Usage, Syntax, Examples and Explanation

What is DMAX function in Excel? DMAX function is one of Database functions in Microsoft Excel that returns the largest number in a field (column) of records in a list or database that matches conditions you that specify. Syntax of DMAX function DMAX(database, field, criteria) The DMAX function syntax has the following arguments: Database: The range of cells that makes up…

DGET function: Description, Usage, Syntax, Examples and Explanation

What is DGET function in Excel? DGET function is one of Database functions in Microsoft Excel that extracts a single value from a column of a list or database that matches conditions that you specify. Syntax of DGET function DGET(database, field, criteria) The DGET function syntax has the following arguments: Database: The range of cells that makes up the list or…

DCOUNT function: Description, Usage, Syntax, Examples and Explanation

What is DCOUNT function in Excel? DCOUNT function is one of Database functions in Microsoft Excel that counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.…

How to generate series of dates increment by 1 year from a single start date in Excel

If need to generate a dynamic series of dates with a formula that increase by one year from a single start date, you can do so with a formula that uses the DAY, MONTH, YEAR, and DATE functions. Formula =DATE(YEAR(date)+1,MONTH(date),DAY(date)) Explanation In the example, B6 is the hard-coded start date and the formula in B7 is: =DATE(YEAR(B6)+1,MONTH(B6),DAY(B6)) To solve this…