Us the INT function to extract Date from Date-Time field
Sometimes we might want to fetch just the date from a Date
time field, for better use i.e. sorting or grouping or filter in Pivot. As Date
time could be messy.
As we know the Dates, Times and Date-Times are serial
numbers in Excel. We normally don’t see the underlying numbers.
We can see the underlying number by formatting the cell to
General.
So here the integer portion is the date serial number and
the fractional part is the time serial number.
So the INT function will help us in fetching the date part
from a Date-Time value. The cell where INT function is used, the formatting of
cell be Date to show just the Date.
No comments:
Post a Comment