Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in tools to expose and even delete duplicates, but they work on existing data after the fact.

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.