 Hello everyone and welcome back to another video. In this video, we're going to be showing you how to add this really cool add-in, which is a date picker into your Excel. You can see the icon we have here in our ribbon, what's the date picker, and the real benefit of it allows us when we're navigating, shall we say, the cells in our worksheet, we're able to get this little pop up, what allows us to click it, and we get the date pop up, what allows us to then click the desired date of our choice and it will get populated into our column or into our desired cell for us automatically. So without further ado, we're going to jump straight into the video and show you firstly how to get the add-on and then how to get it installed into your Excel. Okay, so the first thing we need to do is download the add-in itself. So in order to do that, we just need to navigate to the website. Link for the website can be obviously being seen on our screen now, or you can find it in the description of this video, so just click that link and it will take you straight to the page. Once you get there, we need to scroll about halfway down the page and you'll see this button here for download now for Excel 2007 to 19. Just click that link and it will download a zip file, obviously to your downloads folder. We've already done this, so we'll just jump over to our downloads folder and then continue what you need to do. So if you go to your downloads folder, you can see this zip file, what sits here ready to go. All I want to do is select that file and extract its contents to our desktop. So I'm just going to browse, find my desktop, do OK, and then extract the files. And we can see it's now put there on our desktop. So we're all good to go. What we're going to do is just close these windows, go back to the desktop and then we'll open up Excel. And it's going to open up a blank workbook. Cool, let's get rid of these. We've got a few little pop-ups and updates, obviously, to do, but we'll worry about those later. So in order to get the add-in into Excel, all we need to do is just go to our file tab. We can then go down to options. And then we just need to go to our add-in section on the left here. And then at the bottom here, you've got the section of manage Excel add-ins. So if that's not on add-ins, all you need to do is just change it, but it should default to be defaultly set to add-ins. And then just select go. You're going to get another pop-up. What we're going to do here is go to browse, go to the location that you stored that file. And for us, we've got it here on our desktop. Once selected, we're just going to hit OK. And you can see it's been added there. And it's got the tick box. If you click OK. And now you can see that the date picker is there in the ribbon at the top of the screen. So if you want to put a date in there, all we need to do is select our date from the icon, from the ribbon. And you can see we can go through and select any date that we require. And let's just make that comment bigger so we can see. And we've got a perfect day captured in there for us. If we go into the cell below, because we've put a date in the row above, the add-in is automatically thinking, ah, we're most likely going to want another date because obviously we're putting a value below an existing date. So we get this little pop-up here. So we need to select that. And we can go through and select another date as required. And we can keep going down and adding whatever dates we require. So it's a really, really cool add-in. And obviously it makes it really, really sleek. And it's just really easy to use. And obviously if you've added a date and you want to change it, just go back to where we want to do. And you can then navigate to either a month in the future or month in the past. And then select, obviously, the days that you are after. The other real great use of this is let's say we have a date we want to put in here. But it's not maybe this month or this year. All we can do is go into our pop-up. And we can even go into the date. And you can see it's selected by doing the underline and hit select. And we can now navigate to any of our months throughout the year. So let's go to April. And we can do the same with years. So if we go to the year, you can then scroll through all years of what we've got available in the add-in. And obviously I've gone a bit too far now. But as an example, let's just pick out, oh, am I nearly there, let's just pick out 1991. And then you can obviously select the date from April 1991. And now we're all about to add the date in there for you as well. So it's really, really useful for doing past and future dates in all. Let's say that we don't want to have this pop-up here in the grid. All we need to do is go into our date picker icon, do the drop-down, and we can just untick this option here for show in grid. So if we untick that and navigate away, you can see now that pop-up will not be there. So every time you want to add a date, all you need to do is navigate to your date picker icon here and then select the date, and it will then populate that date into the cell you have selected. But me personally, I really like that show in grid. I just think it gives it a really good look. So we'll just tick that again so we've got it available. The other way you can populate a date in here is to right-click, and you can see you now got date picker automatically set as the top option in our pop-up here for all these options. So you can just right-click, go to date picker, and that will pop-up as well. So this is potentially a good option if you didn't want to have that in grid view, what this will pop-up what you have here at the moment. If you did want to, if for some reason this date picker option was not available in this menu here, all you need to do is go to your date picker, drop-down again, just make sure that it's ticked in the show and right-click. If this is ticked but it's not appearing, then a quick fix will probably be just untick it, so you can see there's no tick there now, and then just tick it again, and that will then hopefully, or should then, repopulate it in there. Not a common error, but I have seen a couple of times where it's ticked, so it should be there, but it's not appearing in that right-click menu, but just a quick untick and then retick will make that show up again. So one problem that you may have with using this particular add-in is saying we've been joining it, it's working in Excel very well, but we now go and close Excel, and now we don't want to save our workbook, and then we go to open Excel once more and go into a blank workbook. You can see that it's actually still there, so we've actually not had the problem I was trying to demonstrate, but the problem that you can sometimes face is if I go to my documents and I did this to my desktop, often what will happen is when you go to reopen Excel, it might no longer show that add-in in your ribbon, and the particular reason or problem that can cause that is if you go into the pop-up we've got here now, and under the general tab we go to the bottom here, you can see that under security this file came from another computer and might be blocked to help protect this computer. So if the add-in is not appearing when you go back into Excel, then what you want to do is come into this pop-up or go into the properties and then go to the general tab and just make sure you unblock, because often what it will do is Excel will be blocking it when it's being added back into Excel. Me, for my example here, it was still in Excel, but I'm still going to just do this unblock here. The reason for that is because if there's any updates I download or install in Excel, I just want to make sure that it's not going to get then missed off in the future, but by unblocking it, it should not cause that to be a problem in the future. So I just apply that and do okay, and then we should now be completely set to start using our date picker going forwards. So once again, we want to put a date in there, we can just select it from here and then within once Excel is recognized that we've got dates in here, then it will obviously allow us to then do the picker from the grid. And the other little tip I just left out is if you go to the date picker and you do it, we can do it from this icon here, you can see at the bottom it has a current time and or current date and time as well and you can see the seconds there as well. And you can see the little prompt we've got there is insert today's date, hint, right click to insert date and time. So we could either left click this to insert our date or if we actually wanted the actual date and time as it is at the moment of time, if you just right click that, you can see that it's put the date and the time in for us as well. So again, another really useful feature if you're wanting to capture the exact date and time as that doing that. So we hope you enjoyed that video and that's giving you a really, well an insight really into adding your first add-on maybe to Excel but also giving you an add-on that's particularly useful and is one that actually should probably be part of Excel because it just seems right to have this available. We've often had the request from clients that they want to have a date selector like this because it's easier for people to populate and put dates in and obviously it just makes it easier for people to not be messing around with any formatting when coming to do those dates. So it's very, very useful for that and it's just a great all-round add-in addition to your Excel platform. So if you did enjoy the video, please do give the video a like. It's greatly appreciated by us and it obviously does help the channel out tremendously. If you haven't already as well, do subscribe to the channel and make sure you hit that bell notification button so you're notified of all of our future videos. We have a lot of videos coming out really soon. So again, by hitting that bell notification button, you'll be notified of them as they come out onto our channel. We've also got a couple of links in the description to this video for our social media. So they're great platforms again for getting contact with us and also being notified of any new videos that are coming out and also interact with the community that's growing of people who are passionate about Excel and obviously have any questions or answers they want and can provide. So thank you very much once again for watching and we'll see you in the next video.