In many versions of Excel, you can use a Microsoft date picker control to create an Excel date drop-down in a cell. Unfortunately, this won't work in 64-bit versions of the popular spreadsheet ...

How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.