How to Extract Date from a Date and Time in Excel

 This Excel tutorial where we'll show you how to extract the date from a date and time in Excel. It's a common task when working with time-based data, and we've got three different methods to help you do just that.

Time Stamps
00:00:13 Method 1: Extract Date from a Date and Time Using Format Cell Feature
00:00:54 Method 2: Extract Date from a Date and Time Using Formulas
00:01:31 Method 3: Extract Date from a Date and Time Using VBA Macro

#########
#########