 Try this function in Excel next time you need a list of dates. All you need to do is use the sequence function and the number of rows you acquire, number of columns, and provide your start date, and then Excel will provide you automatically the list of all the dates within that range. If however, you would like your dates presented in a calendar format going across all seven days of the week, once again, use your sequence function, provide the number of rows, this time provide the number of columns you require, for us it's going to be seven, again, provide your start date, and automatically, again, Excel will the function will return all of your required dates but across the seven days of the week. Be sure to check out our channel for more useful tips and a more in-depth video looking at this particular subject.