Spreadsheets- Advanced Calculations

Calculate the difference between two dates

Use the subtraction (-) operator or the NETWORKDAYS function to do this task.

Worksheet example

To switch between viewing the results and viewing the formulas that return the results

1. On the Tools menu, point to Formula Auditing
2. Click Formula Auditing Mode.

   

To view the dates as numbers, select the cell and click Cells on the Format menu. Click the Number tab, and then click Number in the Category box.

Auditing features

To identify how a formula was created, you can use some of the auditing features.

1. Click on the formula in the formular bar
2. As you click on parts of the formula the cell names (or named ranges) will turn colors.
3. The cells (or ranges) will also turn colors.

   |    Next