00:00I recently published an Excel tips and tricks video on calculating the number of days left
00:04between today and the deadline, but I've received numerous inquiry about excluding weekends and
00:10statutory holiday from the calculation of days left. Well, this is how I do it. To exclude the
00:15weekend between dateline and today, you're going to have to use a function called network days,
00:21and the first argument would be the deadline itself, comma, today's date using the today
00:26function like this. And it's got eight days between today and the deadline. And to apply the formula
00:33to the rest of rows, just double click on this handle, and you're done. Now, if you want to
00:37calculate number of days left but exclude statutory holiday and weekend, you've got to have a repository
00:42of statutory holiday stored somewhere. As you can see, in column F, I do have the repository of all
00:49the available statutory holiday here in Canada. So to calculate the number of days left between
00:55deadline and today, but exclude holiday and statutory holiday, you're going to have to use a function
01:00called network days like this. And the first argument like before, it's going to be the deadline.
01:04The second argument will be today, as in today's date. And the third argument will be the statutory
01:11holiday itself. Make sure you press F4 to make it an absolute reference like this, and then close
01:17parentheses and hit enter. And to apply to the rest of the rows, just double click on this handle,
01:21and you're done.
Comments