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.
