Current Date

The quickest way is to push Ctrl + ; at the same time. Other ways are to use =TODAY() or =NOW().

Both =TODAY() and =NOW() change automatically when the Worksheet is opened or recalculated. =NOW() will also give you the time of the calculation.