Excel contains the feature of any data auto-filling. To perform that, you need to write the first value in the right format(f.e. 01.01.2020) after that you should pull the small square(as at the screen) down, left, up, or right. If you'll pull from 01.01.2020 to 5 positions right, you'll get the automated filled data in the selected area from 01.01.2020 to 06.01.2020. But if you would like to make auto-filling of data more specific, you can code custom macros using VBA(is inbuilt).