How to set the table making date?

1. First, open an excel table and select the area where the format needs to be cleared.

2. Select the (formula) option in the toolbar, click (date and time) in the drop-down menu, and select (date) in the pop-up menu. In the pop-up dialog box, enter the corresponding year, month and day respectively.

3. Select the area to fill. Here, we continue to click (Fill) under the (Start) menu. In the pop-up dialog box, all are selected by default, and the step value is "1" by default: at this time, we find that all selected areas will automatically generate dates.