Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Syed Hussaini , Senior Design engineer , private
Date Posted: 2014/03/10
Kugeshan Perampalam
by Kugeshan Perampalam , Estimator , Interior International Industries LLC

Ctrl + ; for current date

 

Ctrl + ’ for current time

SINIMOL SKARIAH
by SINIMOL SKARIAH , HR Business Partner , NMC HEALTHCARE (Al Zahra Hospital)

Date = today()

time=now()

 

Bindu Sodar
by Bindu Sodar , Document Controller , Stanley Consultants, USA in association with JQEC(Jassim Qabazard Engineering Consultants)

you enter =today() for the current date

Ahmed Aziz
by Ahmed Aziz , Software Development & Testing , Innernet, Inc.

it requires Vb script.

Syed Hussaini
by Syed Hussaini , Senior Design engineer , private

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 

More Questions Like This