Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

See how to: 1.Dates in Excel are whole numbers - called serial numbers. Example: 1, 2, 3, 40900, 40901. 2.The numbers represent the number of days since Dec 31, 1899. 3.The first day in Excel's world is Jan 1, 1900 4.Dates Show Date Number Format 5.Custom Date Number Format 6.Number...



http://www.youtube.com/watch?v=PPzugrrXN6o&hl=en

Hot Game !!!