Entering the Current Date into a Cell
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:
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box