ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Syed Hussaini , Senior Design engineer , private
تاريخ النشر: 2014/03/10
Kugeshan Perampalam
من قبل Kugeshan Perampalam , Estimator , Interior International Industries LLC

Ctrl + ; for current date

 

Ctrl + ’ for current time

SINIMOL SKARIAH
من قبل SINIMOL SKARIAH , HR Business Partner , NMC HEALTHCARE (Al Zahra Hospital)

Date = today()

time=now()

 

Bindu Sodar
من قبل Bindu Sodar , Document Controller , Stanley Consultants, USA in association with JQEC(Jassim Qabazard Engineering Consultants)

you enter =today() for the current date

Ahmed Aziz
من قبل Ahmed Aziz , Software Development & Testing , Innernet, Inc.

it requires Vb script.

Syed Hussaini
من قبل 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 

المزيد من الأسئلة المماثلة