How to Remove Time from Date Timestamp In Excel || Excel Tips & Tricks || dptutorials

In this tutorial let us see How to Remove Time from Date Timestamp in Excel

When you extract dumps from some tools, you will be getting dates with the time format as well. But if you wish to have the date without any time, you need to watch this video now.

Let me take an example like this where I have dates along with time in column A

Best Laptops to use for better speed:

I will show you three ways of removing the time from the dates.

First one, copy the data from column A and paste in column B. Select cells in which you want to remove the time

Right-click and select “format cells”, in the Number tab, In the left pane, click on the Date option.

In the options on the right, select the format in which you want the date to be displayed, I am using the location as the US and selecting this date format.

Click OK.
By this method, you can hide the time from the timestamp and you can see only the date now.

2nd Method:
Using the INT formula
Type formula in cell C6 as = INT(A6).

3rd Method:
This is using the Datevalue formula
Type formula in cell D6 as = =DATEVALUE(TEXT(A6,"dd-mmm-yy"))

So like this, you can remove or hide the timestamp from the date value.

So, friends, this is all about how to remove time from date timestamp in Excel

I hope you have enjoyed this tutorial, If yes, please do give me a like, share and comment.
For further more interesting videos, please do subscribe dptutorials.

Our Recommendations
***************************************************************

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

⚡️Tools for YouTube vlogging:
***********************************************
***********************************************

⚡️You Can Connect with Me at:
***********************************************

#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in english,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, primavera project management,dptutorials,INT formula in Excel,DATE formula in Excel,TIME formula in Excel,DATEVALUE formula in Excel,TIMEVALUE formula in Excel,Extract time from Date and time field,Extract date from Date and time field,Sort cut key for macro,Text Formula in Excel,Remove Time from Date,Timestamp In Excel,remove date from timestamp excel,remove time from date in excel,remove time from date in excel using formula,remove date from time in excel vba

⚡️Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[zqlwzrr]

Finally, someone got it right! Thank You!

[nethonesamba]

It saved my time. Thank you so much Dear

[littleonion]

This really helped me today, thank you.

[samindraseal]

2nd method worked for me as well. Thank you

[dhaniatami]

hello. can you help me?
i tried the first method but my date arent change.
you have to click it 2times and then the date format will change (without time)

am i supposed to click 2times all hundred of data??? :(

[sairiks]

Thanks tried second method and it helped

[Nitin-quxm]

What if someone send me locked Combined date and time data .. then how to separate them ??

[nirmalankur]

If the date changes after 12:00 AM then, how do we get same date?

[rgsfun]

use macro instead of typing formula's.


@

[sharathKumar-bjxv]

update a formula to separate date and time not by using the given options

[timelesstimesgoneby]

How to get rid of all the dates and time

[jutetwine]

why I cannot get? The result is #Value!