How to Add Dates in Microsoft Excel



Guide

  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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline