If you are looking for how to add time to date in Excel, then you are in the right place. In Excel, while working with time and date we often need to get an integrated output where time and date will be shown simultaneously in one cell. This actually gives an exact timing of certain works or projects or anything that is time-based. In this article, we’ll try to discuss how to add time to date in Excel.
Add Time to Date in Excel: 4 Handy Ways
Excel offers different easy ways to show time and date combined. Suppose, we have the following dataset named Adding Time to Date. It has column headers as Date and Time.
We’ll now see different ways to add time to date.
1. Using Arithmetic Formula to Add Time to Date
The easiest way to show time and date combined in one cell is using an Arithmetic Formula. Suppose, we have the following dataset and we need to add time and date in the D Column having a column header as Date & Time.
Steps:
- Firstly, write the following formula in the D5 cell like this.
=B5+C5
Here, B5 and C5 refer to the first Date and Time respectively which are 2/5/2021 and 9:40:00 AM.
- Secondly, press ENTER to get the output.
- Thirdly, use the Fill Handle by dragging down the cursor while holding the right-bottom corner of the D5 cell like this.
- Eventually, we’ll get all the outputs like this.
2. Utilizing CONCAT and TEXT Functions
We can use the combination of TEXT and CONCAT functions to add time and date combinedly. We need to add the time and date in D Column in the following dataset.
- Firstly, write the following formula in the D5
=CONCAT(TEXT(B5;"dd-mm-yyy");" ";TEXT(C5;"hh:mm:ss"))
Here, dd, mm, yy, and ss refer to days, months, years, and seconds.
- Secondly, press ENTER and use the Fill Handle to get all the outputs like this.
3. Using NOW Function to Add Time to Date
We can use the NOW function to show the current time and date. The time and date will change automatically according to the flow of time.
We need to add the current time and date in the C4 cell.
- Just write the following formula in the C5 cell like this.
=NOW()
- Eventually, press ENTER to get the current date and time in one cell as output.
4. Applying Keyboard Shortcut
We can get the date and time by using two different keyboard shortcuts. Suppose we need to add time and date in the C5 by using Keyboard Shortcut.
- Firstly, press CTRL + ; and we’ll get the date.
- Secondly, after getting the date press Spacebar and then press CTRL + SHIFT + ;
- Eventually, after this, we’ll get the time too.
Read More: How to Add Time in Excel Over 24 HoursÂ
How to Insert Today’s Date in Excel
In Excel, we can easily find today’s date. We need to use the TODAY function to do this.
Here, we want to get today’s date in the C4 cell.
- Firstly, write the formula in the C5
=TODAY()
- Similarly, as before, press ENTER to get today’s date.
Add or Subtract Days to/from Today’s Date
We can also add or subtract days to/from today’s date by simply using the TODAY function with the number of days we need to add or subtract.
Suppose, in the C5 and D5 cell we want to get 7 Days Later from Today’s Date and 7 Days Earlier from Today’s Date respectively.
Steps:
- Firstly, we have found today’s date in the B5 cell by using the TODAY
- Secondly, write the following formula in the C5 cell to find 7 Days Later from Today’s Date like this.
=TODAY()+7
- Secondly, press ENTER to get the output.
- Now, write the following formula in the D5 cell to get 7 Days Earlier from Today’s Date.
=TODAY()-7
- Lastly, press ENTER and get the output.
Things to Remember
- The NOW function and TODAY function give outputs that change according to the change of time.
- While finding Add/Subtract Days to/from Today’s Date, we can add or subtract any number to/from the TODAY function according to our requirements.
Download Practice Workbook
Conclusion
That’s all about today’s session. And these are the ways to add time to date in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section.
Related Articles
- How to Add 1 Hour to Time in ExcelÂ
- Add 15 Minutes to Time in ExcelÂ
- Add 8 Hours to Time in Excel
- How to Add 30 Minutes to Time in ExcelÂ
- How to Add Minutes and Seconds in Excel
- How to Add Hours and Minutes in ExcelÂ
- How to Add Hours to Time in ExcelÂ
- Add Milliseconds to Time in ExcelÂ
- How to Add Minutes to Time in ExcelÂ
- How to Add Hours, Minutes, and Seconds in Excel