Insert drop down calendar in excel without date picker

This tutorial demonstrates various ways of entering dates in Excel. See how to insert today's date and current time as static time stamp or dynamic values, how to auto populate a column or row with weekdays, and how to auto fill random dates in Excel.

There are several ways to add dates in Excel depending on what exactly you want to do.

For example, do you want to enter a today's date in some report or invoice?

Date formula in excel dd/mm/yyyy

Or, perhaps you want to insert a date in Excel that will update automatically and always display the current date and time? Or, maybe you want to auto fill weekdays or input random dates in your worksheet?

In a moment, you will learn all these and a few more date entering techniques.

If you are curious to know how Excel stores dates and times, please check out part 1 of this tutorial - Excel date format.