00:00This is how you can find the most recent date within a series of dates, especially if you have large data set.
00:05For example, let's say each employee has four sets of expiration date that are calculated based on factors such as date of hire, probation period, and date of departure.
00:15To determine the most recent date among these four dates, this is how you do it.
00:19First, you select all the dates in your data set like this.
00:23Then you go home, style, conditional formatting, and you're going to select new rules like this.
00:28In here, you're going to select use formula and use this formula.
00:33After that, click on format.
00:35Make sure you're on a fill tab and select the color that you want to color with.
00:39I'm going to select red here and click OK and OK one more time.
00:43As you can see, in my data set with this new conditional formatting, it's selecting the latest date.
00:49If you want to select the earliest date, you have to do reverse.
00:53Select all the dates again like this.
00:55Go home, style, conditional formatting, and after that, over here, now you're going to say manage rule.
01:00In here, you're going to double click on the rule that you recently added like that, and this should come up here.
01:06Here, all you have to do is change max to min like this and click OK and OK one more time.
01:12As you can see, now it's highlighting the earliest date for each employee.
Comments