00:00I'm sure we have all worked with dates in Excel, but have you ever needed to have same dates in
00:05two adjacent rows like this? And on top of that, it needs to be autofill. Bear in mind, normal
00:11autofill does not work in this scenario. This was a question posted in Reddit. There are several
00:16suggestions in the OP, but none of them works. Anyways, this is how you solve it. We start off
00:21with a sequence function, and the first argument is the number of rows that you want, which is
00:26essentially the days. We're going to say, give me a list of 50 days, comma, and our columns will be
00:32one because we're only using column B, comma, and our start is essentially your day. I'm going to say
00:37I'm going to start with May 14. I'm going to just put 14 for now, and then my steps increment
00:42would
00:43be 0.5, and hit enter. You can see that every time it moves down the row, you can see
00:48it's as an
00:49increment of five. Now, if we embed this 14 here with a date function, basically say date,
00:5620, 24 for year, and then five for May, and then 14 for the day itself, what it does is
01:01that it will
01:02show you a huge number, which is the number of days since January 1st, 1900. All you have to do
01:08is to
01:08change the cell formatting on this particular cells here. You're going to select the whole column of
01:14your date like this, and press ctrl 1 to open cell formatting pop-up here. In here, you're going to
01:19select date on the category, and click on OK, and then you're done.
