Showing Date Automatically
There is an Excel file that teaches how to perform the Showing Date Automatically operation.
Excel Template for Showing Date Automatically
This workbook demonstrates showing date automatically using VBA macros on a 15-row data layout.
Hope it is useful.