Real Time Date

[kayza]

Hi All..

When I use = TODAY or = NOW, excel shows the date based on the computer system.
And as we know that function (Today and Now), will change and produce value according to the date on the computer


I was wondering, is there a way to store actual date data even though the computer's date settings are changed?


thanks in advance

 

[admiral100]

Hi,

I think you need to get the "real time" from the Internet or from NTP server....

You can start with the link below :
http://www.myengineeringworld.net/2013/09/retrieve-time-from-internet-server-vba.html