Explanation
Excel handles dates and time using a scheme in whichdates are serial numbersandtimes are fractional values.
If you have dates that include time, you might use theINT functionto extract just the date part.
The INT function returns the integer portion of a number that includes a decimal value.
To see the result formatted as a date, be sure to apply adate number format.
double-check you use a date format thatdoes not include a time.
Otherwise, you’ll see the time displayed as 12:00 AM.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
