Hi - Dave here.
How can you easily remove times from dates, leaving the dates alone?
The solution is easy, but you need to understand dates and times in Excel. In short, Excel dates are just serial numbers and Excel times are just fractions of 1.
For example, the date "April 15, 2022" is the serial number 44666. The date and time "April 15, 2022 12:00 PM" is the number 44666.5. The .5 portion of the number represents 12:00 PM, one half of 1 day. In other words, time shows up as a decimal value attached to the serial number.
This means we can use a function like INT to strip the time, as seen below:
[
download the workbook and read the full explanation]
The article above contains more links related to dates, times, and number formats. Have a look and download the workbook.
Tip: if you ever have dates in Excel that don't seem to be dates, try formatting the cells with the General format. If the date is really a date, you'll see a number. If the date is being treated as text in Excel, nothing will change.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
