Quick date entry in Excel
If you want to quicly enter the date in Excel then simply hold down the “ctrl” key and press the semi-colon key “;” and woosh – the date is entered.
This is a static value unlike using NOW() or TODAY() the date will not update.