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.
Start Excel. In the Type a question for help box, type date and then press .
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.
Print this information if you want to do so, and then Close the Help window.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents