Microsoft Excel Tutorial - How to extract just the Date from Date/Time cell

in Education14 days ago

So I have a column of cells that displays both the date and the time. i would like to extract just the date and put it into another column, but not the time. This could be because I want to use this information for further processing (maybe use it in a vlookup). Here is the best way to do it.

Mathematics & Digital Technologies Education

Videos, quizzes, and other learning resources

Eddie the Magic Monk has 16 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts.

Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 22+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance.


Thanks for using Ecency!
Your post has been voted as a part of Encouragement program. Keep up the good work!
Dear readers, follow and support this author, Install Android:, iOS: mobile app or desktop app for Windows, Mac, Linux:
Learn more:
Join our discord:

Congratulations @magicmonk! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 27000 upvotes. Your next target is to reach 28000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP