Home Excel Functions

# Functions

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

### WEEKNUM Function

0
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...

### MAX Function

0
The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE...

### NOW Function

0
Learn to use the NOW Function in Excel

### SUMIF Function

0
The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators...

### RAND Function

0
The Excel RAND function returns a random number between 0 and 1. This is a rather simple function in Excel, but can...

### HLOOKUP Function in Excel

0
HLOOKUP Function Glossary What is HLOOKUP?HLOOKUP ExampleExact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook or...

### EOMONTH Function in Excel

0
Rock the EOMONTH Function in Excel.

### YEARFRAC Function

0
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:

### TEXT Function in Excel

0
Learn how to use the TEXT Function in Excel.

### WORKDAY Function

0
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....