In the resulting dialog, choose Date from the Allow dropdown. In the Data Tools group, click Data Validation. (For this example, I’ll use cell C4 and add a fill color so it’s easy to spot.) Select the cell to which you’re adding the validation control. You just enter the first and last acceptable dates as follows: Using literal dates is the simplest way to create a validation control that limits input to a range of dates. The browser version supports existing validation controls, but you can’t create them or modify them in the browser. Excel’s Table object isn’t supported in the menu version, so #3 won’t work in. You can work with your own data or download the demonstration. I’m using Excel 2016 (desktop) on a Windows 10 64-bit system. How to return first and last times from timestamps in Microsoft ExcelĬhecklist: Microsoft 365 app and services deployments on Macs Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99 Here are four ways to express dates using data validation: literal values, input values, a list, and formulas. Dates seem to complicate things, but only in your head! This feature handles dates fine. For more info, visit our Terms of Use page.Įxcel’s data validation feature is underused because many users don’t realize how versatile it is, especially where dates are concerned. 
This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews.
We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data validation. Four ways to specify dates using Excel data validationĮxcel's data validation feature is more versatile than you might think.
0 kommentar(er)
