Objective 7. Create a Data Table

GO! with Help

Calculate the Difference Between Two Dates

Excel stores dates as sequential numbers. This is especially useful if you want to calculate the number of days between two datesfor example, the number of days in a payroll period. Use Excel Help to learn how to calculate the difference between two dates.

1.

Start Excel. In the Type a question for help box, type date and then press .

 

2.

In the Search Results task pane, click Calculate the difference between two dates. In the upper right corner of the Help window, click Show All, and then review the information about calculating the number of days, months, or years between two dates.

 

3.

Print this information if you want to do so, and then Close the Help window.

 

Access 2003

Категории