In an excel worksheet how we could update the time or date in a cell at a regular basis?

Ctrl + ; for current date

Ctrl + ’ for current time

Date = today()

time=now()

you enter =today() for the current date

it requires Vb script.

To update the date or time in an excel workshhet it needs to be used VB code which should update the date or time at regular basis the  =Today() or =Now() only displayes the Date and  Time but does not update it at regular basis