![]() (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 create a fun Fly In effect in PowerPoint.How to use VBA to repurpose a built-in command in Word and Excel.Learn advanced Excel skills for less than $35.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |