Learn the Quickest Keyboard Shortcut to Add Dates in Excel

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.

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

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 + ;

Add_Dates_in_Excel_1.

Next, we will try to add Time using a keyboard shortcut in excel.

UMN Business Analytics Bootcamp

Advance Your Business With Our Analytics BootcampEnroll Now
UMN Business Analytics Bootcamp

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 + ;

Add_Dates_in_Excel_2.

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. 

About the Author

SimplilearnSimplilearn

Simplilearn is one of the world’s leading providers of online training for Digital Marketing, Cloud Computing, Project Management, Data Science, IT, Software Development, and many other emerging technologies.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors