Register now or log in to join your professional community.
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