Use Method #2 below, and enter a step value of 1 for sequential dates
For non-standard datetime parsing, use pd
Excel displays a palette of options related to conditional formatting
The above image shows the dates with the alphabetical format month to fill
Excel 2007-2010
Adding current date and time to a cell
See the pictures below:
Nothing will happen if you press <Ctrl>+<D> with only a single cell selected