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 are 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 four 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 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 which because for this 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...