When a date format is applied to this value in a cell, the number 44502 can be displayed as “November 2, 2021”, “2-Nov-21”, etc. If the number is instead 44502.5, it is called a “datetime” because it contains both a date and time. This is equivalent to the following formula: If a date format that includes time is applied to a cell with that contains 44502.5, the value can be displayed as “November 2, 2021 12:00”, “Nov 2 12:00 PM”, etc. In short, any date serial number that includes a decimal value can be considered a datetime. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.