00:00In my previous video, I demonstrated how you can calculate the employee tenure.
00:03Let me know in the comment section if you need the link to that video.
00:06In this video, I'm trying to tackle this question by one of my viewers
00:09asking about how you can do the opposite by tracking training deadlines.
00:13Well, this is how I do it.
00:14In this template for tracking employee training,
00:17there's a column that tracks dates of when the employee completes their training session.
00:21To calculate the remaining duration until expiration,
00:23you'll need to use the following formula.
00:25We're going to start off by using a let function
00:27to store the number of months and days from today until the expiration date
00:30in variable A and B respectively.
00:32The if statement handles cases where if the difference in months
00:35is not greater than zero, it only includes the number of days.
00:39The if error function is there to handle cases where the dates have expired.
00:43Let's hit enter here and apply the same formula to the rest of the rows.
00:46We're going to enhance the visibility of the expired row by applying conditional formatting.
00:50Select the cell conditional formatting use formula of C10 equal to expired.
00:54And if it's true, we change the color of the font to red and bold.
00:58And then you're done.
Comments