### Tip Calculator Template

Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up...

### Sum if date is greater than

Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

### Calculate Work Days in Excel

Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year,...

### Sum if between

To sum if between in Excel, we need to use the SUMIFS Function and define our criteria.

### Sum if less than

Sum if less than with named criteria.

### _xlfn. prefix in Excel

The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.

### Sum if greater than

To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use...

### SECOND Function

The SECOND function in Excel returns the second component of a specified time as a number between 0-59.

### NETWORKDAYS.INTL Function

How many days do I have to work? Find out in Excel.

### MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12.