Microsoft Excel 72 Date and Time Data Validation

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Date and Time Data Validation in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hywmicrosoft

Transcript

00:00One of the things that we can do to get the date and time data validation in Excel is go ahead and

00:12add in validation method to it. For example, if I were to type in 12 Jan 2019 right here,

00:18then you can see that this is a date and it simply accepts it out. But if I want to validate it with

00:24a certain date, then I can simply go around over here on to data right here. And then what you can

00:30do is go to data validation. So once you go ahead and do that over here in the validation criteria

00:36option right here, you can go ahead and select date. And then you can see that you can choose

00:40between or not between equal to and so forth right here. Let's say, for example, I'm going to select

00:46out, let's say in between right here. So I'm just going to select the stop date. Let's say, for

00:51example, I can go around over here and select the stop date right here by taking the cell value as a

00:57reference right here, just like this. Or I can even go ahead and type in a date. For example, I'm going

01:04to type in 1 and 13 right here. And 2018. Let's say, for example, I can add in the date right here,

01:11just like this as well. So I'm going to say 2025 right here. So I'm going to go ahead and press OK.

01:17And since this particular date is within that range, it accepts it. But as soon as I do 2017,

01:24let's say, for example, it says the value doesn't mask the data validation. But as soon as I enter

01:29out the date, let's say, for example, 2023, and I'm going to go ahead and say 16 right here,

01:35then what happens is that the date and time data validation actually takes place right here. And

01:41it simply goes ahead and displays out the date. Same goes with the time as well. Let's say, for

01:47example, if I were to say 1pm right here, this is what you have, you can go to data validation. And

01:53then you can go around for time validation as well. So now you can say data between let's say, for

01:58example, I can go ahead and say 1pm right here, just like this. And I'm going to say 4pm. Let's say,

02:06for example, right here, press OK. So now if I were to go ahead and add in this, it still accepts.

02:13But as soon as I were to go ahead and type in 12, it does not accept because it's not in between

02:191pm and 4pm. So if I were to go around over here into 2, then this is what you have. So if I were to

02:25go around over here onto 4 or 3, then it doesn't accept right there. So that is how you can work

02:30around with date and time data validation inside of Microsoft Excel. So I hope you found this video

02:37useful. Be sure to hit the like button. Don't forget to share this out with your friends and family.

02:43And for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended