Fill Form 2220 Consecutive 2022-2023

Welcome to EXO magic trick number 756. Hey, if you want to download this workbook EXO magic trick 756 to 758, click on the link directly below the video. Hey, this video 756 and 750 6.5, there's going to be two of them, they're going to be two parts. The basic situation is we have a start date here. We're going to do some conditional adding in the second video. But each day of the month is represented by a sheet that has the name one, two, three, four, the third day for the fourth day. So the whole workbook had filled up, be filled up with thirty one of these, if you wanted. I have just seven to make this video short and easy, okay? So the trick is the first one is we want to be able to type in a start date and have it auto populate the first of the month, the second of the month, the actual serial date here. So how are we going to do that? Well, this whole trick, we type in a date here, and the whole trick is going to be predicated on the fact that we've named the sheets one, two, three, four, five, six, seven all the way to 31. So we could use date math if we could somehow extract these sheet names on this sheet. We could just say, "Hey, look at this date," and in this case, it would be add the sheet name - one. Because for this, it is the first of the month. For here, we could say, "Hey, is there a way to look at this date, add the sheet name and subtract one?" And that would add one and give us our date, and that would auto populate. We could have...