When dealing with administrative datasets, you might have to know how to add a date in excel. Date and time play a vital role in data analysis with excel. So, here we bring you the easiest keyboard shortcut to add date and time in excel.
How to Add Date in Excel?
To add a date in excel, you can follow a wide variety of options available in Microsoft excel. A quick example would be the TODAY() function. But the catch is, the TODAY() function is variable and changes accordingly.
So, adding a date that does not change with time using a keyboard short is possible. The simple combination of two keys can work.
The keyboard shortcut is as follows.
CTRL / CMD + ;
Next, we will try to add Time using a keyboard shortcut in excel.
How to Add Time in Excel?
Similar to adding time, we have a simple keyword shortcut to add time in excel. The keyboard shortcut is as follows.
CTRL / CMD + SHIFT + ;
With this, we have come to the end of this article on how to add dates in excel. Please let us know in the comments section below if you have any queries.
Are you looking for career growth in Business Analysis? Sign-up for our exclusive Professional Certificate Program In Business Analysis course and solve complex business problems quickly!
Next Steps
Conditional formatting in excel could offer ways to apply logic to your dataset, but what if you wanted to try something out of the box? Like counting colored cells in excel? The article on counting colored cells in excel can help you learn the fundamentals of Excel VBA and how to customize logic using Excel VBA.
Keen to learn more about Business Analytics with excel? Simplilearn's Professional Certificate Program in Business Analysis course could be of great help. It is considered the best among the industry's top business analytics courses. This Simplilearn program is a result-oriented training and certification program that helps you master statistics and data analytics concepts.
Should you have questions about this tutorial, please feel free to write to us in the comments below. Our expert team will resolve them and will be happy to answer them at the earliest.