Some times while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such 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 Cell will be always populated with the Current Date.

Use the below formula in the Cell where you want the current date to be populated:

Refer the Below Image:




Join over 10, 000+ Excel VBA Enthusiasts & get this FREE e-Book Now!