 Hello everyone and welcome back to another video in this tutorial We're going to be showing you a good tip of how you can use When we're counting dates and this one is going to be showing you how you can count the number of days or specific days So for us in our example going to use the day of Monday So how many how you count the number of Mondays between two given date ranges? So I hope you'll see some benefit in using this a recently come about as we actually happen to use it ourselves And it was one we felt we should share with the rest of you as I'm sure you'll get much benefit from it Obviously, you don't have to be limited to Monday if you could have this to any day of the week you choose But we've just gone with Monday as a random choice in our example here So the first part we need to do as we step through this is obviously enter our start and end date And you'll also notice that my screen has been split in two So on the left you've got our Excel spreadsheet and on the left We've just got the calendar month of June 2019 up just so we can visualize the dates that we're using when it comes to counting these differences So we're going to enter a start date of the third of June 2019 and We'll have our end date as so you say the 6th of June 2019 So the first part we want to do is we can count the number of days Basically within our provided date range and there's many ways to do this But the simplest way you can do this is to go your end date Minus your start date and then that will give you a number of days. So obviously for us it's going to be three The reason we can do this for anyone's not aware is because the dates dates in Excel are actually just numbers so each Whole number that goes up represents a date within the calendar year or a day within the calendar year So if you've ever put like a zero in to excel You'll notice that the date gets defaulted to if you're to put into date format the first of January in 1900 so that starts off at zero and then everything going up from there is just an iteration of a whole number and each Like say whole number that goes up reference a date. So long with a winded Answer there, but that just at least gives you some demonstration of why you can quickly do that Quick subtraction to achieve the number of days In order to do the total Total days excluding Mondays we have to do something slightly different So let's just change our date range just so that we actually do span a Monday So let's say go from maybe the 6th of June And we'll go through until the 11th Cool, so we can see that we're going from this Thursday here Over to Tuesday the 11th over there So we're nearly going a whole week and we can see the total number of days now been updated to five So if we wanted to count the number of days in that range Excluding the Monday we can use a function called network days And more specifically we're going to use a new function Well, I say no it's brought in with Excel 2010 For network days dot intl for international so for the intl and open our brackets So the first things we need to do is just select our date So we'll start right there on our prompt and we've got the end date as well And then the next part what's actually categorized as weekend is These are the days that we want to exclude So if you were to use the default network days function It would count the number of days between your given date range, but it would exclude Saturday and Sunday What we can do the international or this updated function is we're actually able to define the days that we wish to Exclude and obviously around the world and that's why it's called international around the world people may treat Days of the week as weekends differently So in the UK, obviously it's always going to be or typically Saturday and Sunday Where else other people might treat Sunday Monday or Monday Tuesday or any other multiple as their actual weekend For us though, all we're going to do is interested in Monday. So I scroll down this list. You can see Monday only So we're going to go ahead and we're going to double-click this or we could type the number 12 in Close our brackets and hit enter Okay, so we can see that we're actually getting The same number here. So let's actually just recap over that. So total days. Let's just put that in there as well So we're good total days Excluding Mondays So if we'd account this and we go from the 6 to 11th, we can see one two three four five six days To get to the 11th. So it's actually going to be excluding the 10th So you might wonder why we get in these two days what we're exactly the same. Well, the reason we're getting that is because Calculation here is actually not including our first day. So what we can see is the 6 to the 11th Is going to count from it basically 24 hours So it's going to count as in from the 6 to the 7th is one then two three four five Rather than counting the exact the 6th and the 11th in within that So all we need to do is make sure we make this update here our total days is just do our so our end date minus our start date and then just plus one to ensure that both the start date and the end date are included in that count So obviously if you'd account that we want to count each of these days So we want to count the 6th the 7th the 8th the 9th the 10th and the 11th watch is a total 11 days So now when we look at this in recap We can see we've got a total of six days between the 6th and 11th of June And we know that if we exclude the Monday, we've now got five days So we'll see in essence the 6 minus 1 in this case But obviously our network days is more technical than that and it's actually counting all the days and only excluding the Monday So to answer our last question we have here What is the what are the total number of Mondays? All we now need to do is another subtraction where we take our we go equals and we go our total number of days Which is six minus the days that are not Monday And exclude that and we can see we've got the number one So to change our date ranges and just to see how that can now update dynamically Let's go stick on the 6th of June and now let's put in a date of the 25th of June So if we just update this to the 25th You can see everything has all updated our formulas. We can now see we've got a total of 20 days in our date range The total days within that range that are not Monday are 17 days And then therefore the total number of Mondays we have Is the number three and we can count that easily by going to the 6th of June And we can see we've got our first Monday here on the 10th Our second is on the 17th And our last and third is on the 24th So that is how you can use a couple of different formulas in excel To drive at the result to identify the total number of specific days Within a date range So we hope that has given you some good insight and obviously it goes out saying that if you want to get more technical With that you could literally can zip dense these three separate cells or separate formulas we've done Into one Larger sort of say formula Which will obviously give you that detail within a single cell rather than splitting it out over multiple cells But hopefully that breaks it down for you So you can see how the logic works and you might even have uses for this these logics separately on their own But hopefully overall it gives you the A way of doing this if you need to achieve that result So thank you very much for watching if you haven't already please do subscribe to the channel Hit that bell notification button so you're notified of all our future videos Also, if you did enjoy the video, please do give the video a like It's greatly appreciated by us and it does really help the channel. So thank you very much once again and we shall see you in the next video