Here are four ways to express dates using data validation: literal values, input values, a list, and formulas. I’m using Excel 2016 (desktop) on a Windows 10 64-bit system.

By smartly using cell borders, shading, data validation, and other formatting techniques, you can improve the visual appeal of your Excel spreadsheet.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.