Excel date is automatically generated every 15 days.

1. Open the excel table and enter the start date in any cell.

2. Then point the mouse to the lower right corner of the cell, and the mouse pointer will become a cross. Now hold down the left mouse button and drag the mouse down or right.

3. When dragging the mouse, the automatically generated date in the cell will be displayed, and the time interval is set to 15 days. After dragging to the end of the displayed date, release the left mouse button.

4. This will automatically generate Excel every 15 days.