Calculating Date In Bulk
There is an Excel file that teaches how to perform the Calculating Date In Bulk operation.
Excel Dashboard for Calculating Date in Bulk
This workbook demonstrates calculating date in bulk using VBA macros on a 1-row data layout.
Hope it is useful.