Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Use DATEDIF in Excel: Calculate Age and Date Differences

DATEDIF is a handy Excel function for finding the gap between two dates in complete years, months or days. It is the standard way to calculate a person’s age, an employee’s length of service, the age of an invoice or the time left on a contract. The function is a little unusual, because it does

Standard

How to Calculate IRR in Excel: IRR, XIRR and NPV Explained

Internal rate of return, or IRR, is the yearly return that makes the value of an investment equal to its cost. Excel calculates it with one function, as long as you list the cash flows in order, with money you pay out as negative numbers and money you receive as positive numbers. This guide explains

Standard

How to Calculate Loan Payment in Excel Using the PMT Function

The PMT function is the quickest way to find the regular payment on a loan in Excel. You give it the interest rate per period, the number of payments and the amount borrowed, and it returns the payment. It works for car loans, mortgages, personal loans and any loan with equal payments. This guide explains

Standard

How to Convert Text to Number in Excel: 7 Fast Methods

Numbers stored as text are a classic Excel problem. The cells look like numbers, but SUM returns zero, sorting puts 100 before 9, and VLOOKUP fails to match. This usually happens when data is imported from a website, a CSV file or another system, or when a cell is formatted as Text before you type