Dans le cours : Excel Tips Weekly

Accédez à ce cours grâce à un essai gratuit

Inscrivez-vous aujourd’hui pour accéder à plus de 24 800 cours dispensés par des experts.

Controlling date entry restrictions using data validation

Controlling date entry restrictions using data validation - Tutoriel Microsoft Excel

Dans le cours : Excel Tips Weekly

Démarrer mon mois d’essai gratuit Acheter pour mon équipe

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,…

Table des matières