From the course: Excel: Data Validation in Depth
Join today to access over 24,800 courses taught by industry experts.
Validating dates with data validation - Microsoft Excel Tutorial
From the course: Excel: Data Validation in Depth
Validating dates with data validation
- [Narrator] Not unlike any other validation we've covered up to this point, dates can also go wrong. They can be entered incorrectly, or people can sometimes just enter a date that doesn't exist, like February 30th. Dates can be a valuable data point and we can do a lot with dates data. What we can't do a lot with is bad dates. Explore California has decided that they would like to offer summer internships to recent high school graduates. Let's explore some of the different options for date validation, working with the date field for their up and coming time tracking sheet. I'll go ahead and highlight A12 through A26. Since this is a summer program, we want to ensure that all of the new interns do not enter dates that are invalid. The date range should be from May 15th to August 15th. Let's go ahead and set the date validation. Let's go to Data, Data Validation. From the Allow, we'll hit the dropdown and we'll choose…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.