Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

You can add a zero before a number in Google Sheets and Excel using this tutorial. You need to change cell formatting or use function.

Formula Method The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some ...

Important : After entering the INDEX formula in the cell you want the number to appear in, you must then press Ctrl+Shift+Enter—a step that encloses the entire formula in curly brackets— { }—and ...

Either way, counting the number of records that fall between two dates is easy using the COUNTIFS () function (which isn’t available in Excel 2003 or earlier).

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.