Switch to Data view. 2. On the Home ribbon tab, from inside the Calculations group, click New Table. 3. In the formula bar, enter the following, and then press Enter: Date =CALENDARAUTO(6) or you may want to use the CALENDAR function. like DATE = CALENDAR (DATE (2020,07,01), DATE (2025,06,30)) At the bottom-left corner, in the status bar, notice the table Read More