Home Sample Files Register Books and e-books Forums Support Contact Search
Login
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007

Understand Excel date serial numbers and custom date formats (Excel 2013):

Lesson 3-7 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 3: Advanced Functions
Lesson: Lesson 3-7 Understand Excel date serial numbers and custom date formats Understand Excel date serial numbers and custom date formats, a thumnail from Lesson 3-7 of the Excel 2013 Expert Skills video course
Description:

Date serial numbers and custom date formats are covered in depth in this lesson. The lesson provides a complete explanation of date serial numbers in Excel 2013. All dates in Excel are stored as date serial numbers, and understanding this enables you to create formulas that manipulate dates in many useful ways. This lesson demonstrates how to calculate the number of days between two dates and shows how times are represented as fractions in date serial numbers.

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