| Home : September 10 2016 Computer News : Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more |
|
Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more |
September 10, 2016
If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an equivalent Serial Number dating back to January 1, 1900 at 00:00:00 (hours, minutes, seconds). Not to be confused with Julian dates, which mainframes and many programming languages use, Excel serial numbers are unique to Microsoft products.
Open Excel and enter the numbers 1 through 5 in cells A3 through A7. Highlight the range, then from the Home tab’s Number group, select Short Date from the drop-down list. Notice that your numbers 1 through 5 have changed to the following dates: 1/1/1900 through 1/5/1900.To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3063622/software/mastering-excel-date-time-serial-numbers-networkdays-datevalue-and-more.html#tk.rss_howto
|
|
|
|
|