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 ...

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

If you select the "Fill Series" radio button, Excel fills the cells with dates that increment by one day, starting from the date you typed.

Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that have a date.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.