![]() To insert the current date as well as the current time, use the below formula: =NOW() To insert the current date, use the below formula: =TODAY() There are a couple of formulas that you can use to quickly insert the date and time in Google Sheets. Remember to convert the formula to value to make sure the combined timestamp (with date and time) is a static value (hint: use Paste Special to do this). In case you want to get a combined value of date as well as time, you can first use these two keyboard shortcuts to insert the date and time and then simply add these two cells (as shown below). This means that if you make any changes in the worksheet or close and open it, these date/time values will not change. ![]() Note that these keyboard shortcuts would insert a static date and time value. To insert the current time Control + Shift + : (hold the Control and Shift keys and press the colon key). ![]() To Insert the current date Control + : (hold the Control key and press the colon key) If you want to quickly insert a timestamp in one cell (or a few cells), you can use the below keyboard shortcuts:
0 Comments
Leave a Reply. |