If you find any post useful then, please do share with others. Thanks!

Popular Posts


Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Monday, March 20, 2017

Extracting Date from a Date Time - in Excel

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