How to get Current Date & Time in Excel using Formula and Shortcuts (Both Dynamic & Constant)

This video show you how to get date and time in Excel using formula and keyboard shortcuts. We will see both static date and time which remains constant and the dynamic date and time which gets new value whenever the excel sheet is opened and refreshed.