Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

DSUM Function

0
The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

EXACT Function

0
The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If...

TODAY Function

0
Learn to use the TODAY function in Excel.

NOW Function

0
Learn to use the NOW Function in Excel

NETWORKDAYS Function

0
The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically excludes weekends...

DATEDIF Function

0
The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A common error...

DATE Function in Excel

0
The Excel date function is built directly into Excel. You can use this function in a variety of useful ways.

VLOOKUP Function in Excel

0
Comprehensive VLOOKUP glossary with downloadable examples.

CUMIPMT Function

0
How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the...

RANK Function

0
The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Sum if between