00:00Manually entering the date on your dataset like this can be laborious, tedious, and sometimes
00:04lead to error.
00:05Let me show you another way you can enter the dates using an add-in called mini calendar.
00:10Go to home and after that navigate to add-in.
00:12In the add-in, you're going to click on more add-ins here and you're going to search for
00:16a text called calendar like this and you're going to be adding these add-ins called mini
00:22calendar and date picker.
00:23Click on add and click on continue.
00:26What that does is that it introduces a new widget called mini calendar here like this.
00:30I'm going to drag this here somewhere here like this and now to use this mini calendar
00:36you select the cell that you want to insert the date to and you select the date from the
00:41mini calendar like this and it populates the date nicely for you.
00:45Select the cell again and maybe go somewhere in the future like that and let's say if you
00:50want to go to the past select the cell and go to the past date like this.
Comments