Microsoft® Excel® 2010 Inside Out

Chapter 15. Formatting and Calculating Date and Time

Understanding How Excel Records Dates and Times

Entering Dates and Times

Formatting Dates and Times

Calculating with Date and Time

Working with Date and Time Functions

YOU can use date and time values to stamp documents and to perform date and time arithmetic. Creating a production schedule or a monthly billing system is relatively easy with Microsoft Excel 2010. Although Excel 2010 uses numeric values to count each nanosecond, starting from the beginning of the twentieth century, you can use formatting to display those numbers in whatever form you want.