How To Insert Dates In Excel Automatically?

Use the keyboard shortcut Ctrl + ; to insert the current date

Use the formula =TODAY() to display the current date automatically

Use the formula =NOW() to display the current date and time automatically

Format the cell as a date if the result appears as a number

Drag the fill handle to auto-fill a date series

Enter two dates and use AutoFill to continue the sequence

Use the SEQUENCE function to generate a list of dates

Use a formula like =A1+1 to create the next date based on the previous cell

Use a table or structured reference to auto-copy date formulas down a column

Suggested for You

Trending Today