< Go Back

Extract date from a date and time

Extract date from a date and time

In this article, I will explain to you How to extract a date from a date and time in Excel with Examples. Firstly you should know that Excel manipulates data in the form of dates and time using a simple method where dates are represented as serial numbers and times are represented as fractional values.

Figure 1. How to Extract date from a date and time in Excel

For instance, the date September 26, 2016, 21:30 is saved in Excel as the number 42639.89583. In this example, the number 42639.89583 is representing the date September 26, 2016, and .89583 is representing the time 21:30

Extract date from a date and time using INT(A1)

Using int (A1) where A1 is the cell containing the time and date and INT is the function. The time part of the date and time (which is saved as the part after the decimal) is discarded. Using the TRUNC function will also yield the same result.

Extract date from a date and time using TRUNC(A1)

The same thing will happen as above. However, there is a difference when it comes to signed integers.

       

Figure 2. How to Extract date from a date and time in Excel using INT and TRUNC command

Resultantly, using either one of the above methods will extract a date from a date and time in Excel. However, Make sure that you use a format for the date in the result that does not include time parameters. If not so you will see the time displayed just as before. That is not what we want in this case.

In Excel, for extracting dates in dates and times there is not much difference in using INT or TRUNC function for extracting an integer from a date and time. Usually, with INT function, it rounds the number down to the nearest index which makes a difference only when values are negative. Their functionalities are somewhat different but it doesn’t affect a person using positive integers like in this case.

Notes

  • Date and time can never be negative.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar