From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Controlling date entry restrictions using data validation

Controlling date entry restrictions using data validation - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Controlling date entry restrictions using data validation

“

- [Instructor] In this worksheet, 2 we're tracking orders for the year 2021, 3 and we haven't put in the shipping dates just yet. 4 We want to make sure that those shipping dates 5 are all within the year 2021. 6 We also want to make sure that the entries here 7 are more than two days later than the order date 8 because the products we deal in 9 require some assembly and packaging. 10 We already have a restriction set up for column B 11 by way of Data Validation. 12 And all of these orders here must be in the year 2021. 13 So we want to do the same thing in column C, 14 but add on to that idea 15 that we also want to make those shipping dates later. 16 So as we select column C, on the Data tab, 17 go into Data Validation. 18 On the Settings tab under Allow, 19 we've got options for date, 20 but none of the choices here 21 really relate to data in different columns. 22 So what we need to do is make another choice,…

Contents