CURRENT AND PREVIOUS DATE SHOULD COME AUTOMATICALLY IN EXCEL ON OPENING

[chiranjiv poojari]

Hi team,
I want to know the code for running macro, the current and previous date should come automatically and while saving the file the time should appear in excel sheet .

Today Date​	21/09/2019​	Time : When we save the file​	​
Previous Date​	20/09/2019​	​	​

 

[vletm]

chiranjiv poojari
Please reread Forum Rules to get some hints what / how to open a new thread.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[herofox]

where's the file as mr. Vletm informe You ?!!!!