This means the main task in this problem is to remove the decimal portion of the number.
Note: This example requires valid dates.
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.
However, the time will still be there.
If the goal is topermanentlyremove the time portion of a timestamp, see the formulas below.
Note: Excel’s date formats are flexible and can becustomized in many ways.
verify you use a date format thatdoes not include a time.
Otherwise, you’ll see the time displayed as 12:00 AM even though the time value has been removed.
This is normal Excel behavior.
TRUNC function
You will sometimes see theTRUNC functionused as an alternative to the INT function.
Like the INT function, the TRUNC function also removes the decimal portion of a number.
Unlike INT, the TRUNC function doesn’t round, ittruncatesa number.
So, in practice, there is no difference between INT and TRUNC in this particular case.
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.
