 Hello everyone and welcome back to another video. So today is another top-tip video and we're going to be showing you a Function available in Excel that if you're not already using it It's one you definitely add to your list because it will save you a heck of a lot of time when it comes to working with dates So out of those LA we'll just jump into our three scenarios We've got and how you can use this particular function So the first one we can see we've got a single column at the moment We've only got a header for date and what we want to do here is we want to have a list of dates between a start and day and an end day Normally well many people maybe less experienced in Excel might they might type a date in manually and They'd have to repeat this process until they've got to the desired number of days that they wish you could maybe drag this down Or you might see people do this the previous value plus one But nonetheless obviously it takes you a little while to do that and nonetheless if you've got to do quite a few number of dates Maybe like a year's worth you then obviously have to drag this formula down all the way to row 300 and obviously a bit different for me because I'm starting higher up But you've got to drag it along like 365 rows to get that full year rather than do that all we need to do is use this one formula we need to do is equal as a sequence and The first thing we need to do is enter the number of rows for this so for us This can be days, so let's say we want to do 365 days as my first example We've only got one column We want to all in one date column So we're going to put number one and the date we want to start from we'll say the first of January 1st of January 2022 We're in quotations close bracket and hit enter and you can see what has now done for us It has done or has expanded the range of to whatever range it is that we need and you can see each row is now Containing that next day. I've got a bit of formatting obviously what's falling apart here So we can just simply do this and go into short date and it's now working for us If however we were to change the day we need to start from I don't know Maybe let's say we start from the 1st of March or we need to do is change it here hit enter And you can see that that's now going to reflect for us elsewhere in the next example We're going to be using exact that same Function but this time we want to have our date spread across seven columns So you can see we're trying to identify here all your Mondays your Tuesdays so on and so forth You might want to do this if you're creating a take a calendar table In which you want to do a lookups or other calculations based upon so all we need to do in the same scenario is go equals sequence once again and Go down to that one there and this time we want to do let's make up a number This is a 52 because we want to do 52 weeks. So type in 52 However, this time I've got seven columns and we'll type the number seven comma once again and So what's the start date? So I know the 1st of August was on a Monday. So we can do that just so we can stay true to the dates Close brackets hit enter and you can see that has now built our calendar in the exact Parameters that we require. So if you look at Monday, you can see down this Monday column These days are all going to be Mondays and so on for those other days of the week the last example we have here is we now want to just do slightly a little bit extra with that formula and we're going to About to get this to do Sequentially give us a list of all of the Mondays. So basically we commencing for our particular range so once again, we'll go equals sequence and Go down to a sequence and this time I want to do again 52 rows because it relates to the number of weeks in a year So 52 Columns again, we're really now in one column band rather than that last example of seven another column I mean comma sorry my start date which again, we've got make sure we do in quotations We'll go for the first of August once again. So I know that was a Monday Rotations and then this time rather than close brackets We're going to do another comma and in this section where it says step This is asking us. What is the step? We want to jump in between each of these dates or in other words each row What is the step that we want to jump because we want to do do this weekly? So this column will gives us the Monday or the start date for each week We're going to use the number seven But if it was applicable to what you're doing you could put any number there that you so sorry once I've done that hit Close brackets and hit enter and again, you can see really quickly We now have a list of all of our dates as required in this single column So try to keep this video nice and short I hope that gave you some insight into a new formula that you maybe weren't aware of or is going to help you Significantly reduce the amount of time you spend on doing similar activities in your Excel work If you did enjoy this video, please don't forget to hit that like button It'd be greatly appreciated by me and obviously it helps that all important YouTube algorithm If you haven't already or if this is your first time find the channel, please Don't forget to subscribe that way you should be notified of any future videos as and when they come out and very lastly If you do have any questions about this video, please drop me a comment below and I will get back to you as soon as I can Thank you very much for watching and I'll see you in the next video