Watch this video to learn how Microsoft Excel handles dates and times.
Also, learn how to find errors in your date values.
Watch my YouTube video
Video 00024 Intro_Working with DATE and TIME_in Excel
The site is about Microsoft Excel.