Exceljet

Quick, clean, and to the point

Apply date format

Windows shortcut 
CtrlShift#
Mac shortcut 
#

Apply the Date format with the day, month, and year.

Related videos

Tip: How to use VLOOKUP with an Excel Table
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.