Data Validation Calendar

Data Validation Calendar. First, you’ll set up a grid, enter your dates, and then use some formulas and formatting. From the allow drop down in the.

Click the data tab in the ribbon menu, then click data validation. under settings, pick what type of data you want to allow. Use the today and now functions to show today’s date and time on a form.