# How to Add Time to Date in Excel (4 Useful Methods)

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

<< Go Back to Add Time in Excel | Calculate TimeÂ | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF