How to Add Dates in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Type any date on your excel cell.
2. Drop down the cell and it will be auto arranged.
3. If the dates don't auto-arrange, click AutoFill Options and select Fill Series or your desired format.
4. If you want to change the date format, right-click the cell and select Format Cells.
5. Select your desired date format, then click OK.
6. Drag down to autofill, and the date format will update automatically.