{"id":12143,"date":"2012-06-17T17:52:12","date_gmt":"2012-06-17T17:52:12","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1893"},"modified":"2022-08-10T12:37:52","modified_gmt":"2022-08-10T12:37:52","slug":"entering-the-current-date-into-a-cell","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/entering-the-current-date-into-a-cell\/","title":{"rendered":"Entering the Current Date into a Cell"},"content":{"rendered":"
Sometimes while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such a case, you need to change the Cell Value every day with the current date. Using the below small trick, you can make it automated. It means the Cell will be always populated with the Current Date.<\/p>\n
\nUse the below formula in the Cell where you want the current date to be populated:
\n
\n =TODAY()<\/strong>
\n
\nRefer to the Below Image:
\n
\n