Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Understand date serial numbers:

Lesson 4-2 from: Microsoft Excel 2013 Essential Skills (147 Video Lessons)
Understand date serial numbers
Play Video
Play The Video
ExcelCentral Icon 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 Excel date serial numbers explained. Thumbnail from Excel Basic Skills 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.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email