There are many in-built Excel Functions that can help you in working with Dates and Time. It can assist you in showing today’s date, the current time, and represent dates as Months, Years, and even calculate difference in 2 dates.<\/p>\n
1. Getting Today’s Date<\/strong><\/em><\/p>\n In the cell where you want to display today’s date, key in the following formula: Depending on your PC’s Regional Settings (Setable in Control Panel), you will get today’s date displayed in MM\/DD\/YYYY or DD\/MM\/YYYY format.<\/p>\n The problem will this approach is that every the Excel file is re-calculated, the date will change and display the latest day’s date.<\/p>\n If you wish to only display today’s date, but do not want it to change in the future<\/strong>, there’s a little known shortcut to do this. Go to the cell where you want to get today’s date, and simply press Ctrl + ;<\/strong><\/p>\n 2. Getting Today’s Date & Time<\/strong><\/em><\/p>\n In you want the date and time, both to be displayed, more like a time stamp, use the following formula: It will display as 24\/7\/2012 12:33<\/p>\n If you only want the time, like a time stamp<\/strong>, and do not want the time to ever change, then simply press the following keys: Ctrl + Shift + ;<\/strong><\/p>\n And if you want to display both the date and time stamp in a single cell, combine the 2 functions<\/p>\n Select a cell and press CTRL+; then press the SPACE BAR to add a space, and \u00a0then CTRL+SHIFT+;
\n=TODAY()<\/strong><\/p>\n
\n=NOW()<\/strong><\/p>\n
\n\t\t