Make Dates from Drop Down Lists in Excel
How to use a drop down list (data validation) to create a date in Excel.
This technique creates a fully functional date serial number that Excel recognizes so you can perform any required date-based calculations or output display changes.
Additional Resources
Dates from Text in Excel (msft)
Data Validation (msft)
Data Validation for Dates (contextures)
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: Ensure that your Data Validation Drop Down Lists or Menus are automatically updated with ...
Tutorial: How to make a data validation drop-down list arrow that is always visible in Excel. This ...
Tutorial: This trick allows you to easily perform a nice visual analysis of data in Excel without m...
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)