Lesson 4-2 from: Microsoft Excel 2013 Essential Skills (147 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Understand date serial numbers

Play The Video

ExcelCentral.com

Play

Back 10 Seconds

Slower

Faster

Full Screen View

Online Video Course: | Microsoft Excel 2013 Essential Skills | |
---|---|---|

Session: | Session 4: Making Your Worksheets Look Professional | |

Lesson: | Lesson 4-2 Understand date serial numbers | |

Description: |
Excel Date serial numbers are fully explained in this video lesson. You'll be amazed to find that (in Excel) every date is a time and every time is also a date. You'll learn how to format a date to show a date, a time, or both a date and a time. Understanding Excel date serial numbers are the key to using date arithmetic in Microsoft Excel. You'll use date arithmetic in a simple formula that will return the total number of days in the last century. The lesson discusses how Excel is unable to represent dates before 1900 and in this (and in subsequent lessons) you'll learn how to work around this limitation. |