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

Get FREE Advanced Excel Exercises with Solutions!

In many situations, we need to display the date and time simultaneously in one single cell in an excel worksheet. Maybe we have two columns containing the date and time separately, and we want to display them together. Or perhaps we want to display the current date and time combined in a cell. In this article, I will show you how to add date and time in excel and try to cover all the possible situations.

## 4 Useful Methods to Add Date and Time in Excel

In this section, we will demonstrate 4 effective methods to add date and time in Excel with appropriate illustrations. To illustrate, we have taken a worksheet where in one column we have some dates and in another we have times. (see the figure below) Now we want to add the date and time and combine them in a single cell. To do that, let’s use our first method.

### 1. Perform Arithmetic Operation to Add Date and Time

In this method, we will perform a simple arithmetic operation, which is adding date and time. Here follow the steps below.

Steps:

• First, choose a cell where we want to combine the date and time. Here, I have chosen cell D5. • Now, write the following formula in the cell.
`=B5+C5` • Now, press Enter key, and you will see that the Date and Time have been combined in the cell. • Now, to perform the same task for the cells below, use Fill Handler to drag and copy the formula of D5. • Consequently, you will see that all the dates and times have been combined and expressed under the Date & Time. • This method is straightforward yet efficient and quick.

### 2. Combine CONCAT and TEXT Functions to Add Date and Time

In the 2nd method, we will use the CONCAT and TEXT functions to accomplish our task. To do that, follow the steps below.

Steps:

• Like the first method, select a cell where you want to add the date and time. In the figure below, I have selected the D5 • Now input the following formula and press Enter.
`=CONCAT(TEXT(B5,"dd-mm-yyy")," ",TEXT(C5,"hh:mm:ss"))` • Here we can see that the date and time have been combined in cell D5. Now to apply the formula in the other cells, use the Fill Handler like in method 1. We will get the following result. • As we can see, this method also yields the same result, but the time is in 24 hours format, which can be changed by changing the format.

### 3. Use Shortcut Key to Add Date and Time

Sometimes we may need to input the current date and time combined in a cell. To do that, we can use 2 shortcut keys. To do that, follow the steps below.

Steps:

• Select a cell where you want to input the current date and time. Here we have selected cell C4. • Now, press Ctrl + ; (Semicolon). As a result, the current date will be shown like the figure below. • Now, press the Spacebar key and type Ctrl + Shift + ; (Semicolon). Consequently, the current time will be inserted like the figure below. ### 4. Apply NOW Function to Add Date and Time

If you want to add the current time and date in your worksheet which will be dynamic, you can use the NOW function. To do that, follow the steps below.

Steps:

• First, choose a cell where you want to input the time and date. This time, we have chosen cell C4. • Now input the following formula.
`=NOW()` • Press You should see the following result. • This Date and Time will update themselves when we reopen the worksheet or perform any operation on the worksheet.
• We can also change the format of the cell if necessary.

## Add Date and Time While Printing in Excel

While printing an Excel sheet, we may need to record and display the printing time and date on the sheet. To do this, follow the steps below.

Steps:

• First, go to the View tab and click on Page Layout • As a result, you will see the worksheet in a page layout containing the Header and Footer sections. (See the figure below) • You can add the date and time either in the Header or Footer. This time, I chose the Footer. The Footer has 3 parts for inserting anything: Left, Middle, and Right. Here I have chosen the Right part. • To insert the date and time, go to Header & Footer tab and select Current Date. • Now press the Spacebar key and again select Current Time. • Now, if you go to print preview, you will see that the printing page has the date and time in the bottom right corner. ## Things to Remember

• Use the first two methods for combining date and time, previously separated into two distinct columns.
• Use the 3rd and 4th methods for adding the current date and time.

## Related Articles Aniruddah Alam

Hi, I am Md. Aniruddah Alam from Dhaka, Bangladesh. I completed my Bachelor's degree in Naval Architecture from BUET. Currently, I am working as an Excel and VBA Content Developer. Here, I always try to present solutions to Excel-related problems in a very concise and easy-to-understand manner. In my leisure time, I love to read books, listen to podcasts, and explore new things.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  