To display the current date and time,which is updated each time the workbook is reopened,
use the TODAY function.

Name: To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function.
Brand: Quizplus
Rating: 4.8 (35 reviews)

Question

Quizplus · Accepted Answer

The TODAY function returns the current date, but it does not update automatically each time the workbook is reopened. Thus, we need to use a macro or a formula with VBA code to update the date and time automatically each time the workbook is opened.

To Display the Current Date and Time,which Is Updated Each