Formulas to Find the Date & Time Calculations in Excel 365!!
Tags: excelformula, excelformulas
Published: 2020-10-16 11:57:17

---
title: Formulas to Find the Date & Time Calculations in Excel 365!!
published: true
date: 2020-10-16 07:56:45 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-find-the-date-time-calculations-in-excel-365/
---

## Excel Formulas to Find Date & Time: Add, Subtract, Datetime, Time Difference, Age Calculation:

In this article, we are going to learn the Formulas to Calculate the Date and Time Calculations in Excel Office 365. It includes Addition, Subtraction, Datetime, Time Difference, and Age Calculations. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Excel Formulas to Add Date & Time:

- From the below formula, you can easily Add the days, weeks, months, and years to a date-time.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(A2)+4,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(A2)+7,[DAY](https://geekexcel.com/how-to-use-day-function-in-excel-365/)(A2)+58+7\*14)**

### Example 1:

- For example, we will show how to add date, month, year in a date-time in the below screenshot.
- We entered the input dates in **Column A**.
- After applying the given formula, it displays the result in a Selected Column.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv12.png)

- To Add the days, hours, minutes, and seconds in a date-time, use the below formula.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(A2)+0,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(A2)+0,DAY(A2)+5)+([HOUR](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)(A2)+5)/24+([MINUTE](https://geekexcel.com/how-to-use-minute-function-in-excel-365/)(A2)+50)/1440+(SECOND(A2)+15)/86400**

### Example 2:

- In the below screenshot, we give the inputs in **Column A**.
- Then, enter the given formula to calculate the results.
- After applying the formula, it will display the result in a selected column.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv13.png)

## Formulas to Subtract Date & Time:

- Use the below formula, for subtracting the date, week, hours in a date-time.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(A2)+0,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(A2)+0,[DAY](https://geekexcel.com/how-to-use-day-function-in-excel-365/)(A2)+0+7\*5)+([HOUR](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)(A2)+5)/24+([MINUTE](https://geekexcel.com/how-to-use-minute-function-in-excel-365/)(A2)+0)/1440+([SECOND](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/)(A2)+0)/86400**

### Example:

- In the below screenshot, we enter the input dates in **Column A**.
- After applying the given formula, we will get the output in **Column B**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv14.png)

## Formulas to find the Difference between Two Date Times:

- The below formula is used to find the difference between two dates or two times and return a  specified format.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(A2)+0,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(A2)+0,[DAY](https://geekexcel.com/how-to-use-day-function-in-excel-365/)(A2)+0+7\*5)+([HOUR](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)(A2)+5)/24+([MINUTE](https://geekexcel.com/how-to-use-minute-function-in-excel-365/)(A2)+0)/1440+([SECOND](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/)(A2)+0)/86400**

###  Example:

- In the below image, we give the input in **Column A**.
- Then, enter the given formula for calculating the difference between two date-times.
- After applying the formula, it will show the results in a selected cell as shown below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv19.png)

## Excel Formulas for Calculating the Age-based Calculations:

- Use the below formula, to calculate the age based on a given date and return to year, month, day in a date-time.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([ISBLANK](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)(A3),””,[DATEDIF](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)(IF([TODAY](https://geekexcel.com/how-to-use-today-function-in-excel-365/)()<A3,TODAY(),A3),IF(TODAY()>A3,TODAY(),A3),”y”)&”Year(s)”&DATEDIF(IF(TODAY()<A3,TODAY(),A3),IF(TODAY()>A3,TODAY(),A3),**

### Example:

- For example, we will enter the inputs in **Column A** as shown in the image.
- After that, apply the given formula, and it will display the result in a selected **Column B**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/cv22.png)

## Explanations for Formula Syntax:

- **DATE** –  The Excel [**DATE Function**](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/) is used to combine three different values and return them as a date.
- **MONTH** – This function will extract a month from a given date as the number between 1-12. For more details on **[MONTH Function](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)**.
- **YEAR** – The main purpose of this function is to get the year from the date and returns as a 4-digit number. Read more on the[**YEAR Function**](https://geekexcel.com/how-to-use-year-function-in-excel-365/).
- **HOUR** – In Excel, the [**HOUR Function**](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/) will help to return the hour component from a given time as a number between 0-23.
- **MINUTE** – It will display minutes of time as a number between 0-59. Read more on [**MINUTE Function**](https://geekexcel.com/how-to-use-minute-function-in-excel-365/).
- **SECOND** –  This function will return seconds of time as a number between 0-59. For more details about the [**SECOND function**](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/).
- **DAY** – It displays the day of a date. Read more on the [**DAY Function**](https://geekexcel.com/how-to-use-day-function-in-excel-365/).
- **IF** – The main purpose of the [**IF  Function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/) is to return one value for a TRUE result and another one for a FALSE result.
- **ISBLANK** – The Excel[**ISBLANK Function**](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/) is used to test if the cell is empty or not.
- **DATEDIF ** – This function will calculate the difference between two dates. Read more on the   [**DATEDIF Function**](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/).
- **TODAY** – In Excel, the **[TODAY Function](https://geekexcel.com/how-to-use-today-function-in-excel-365/)** is used to return a current date on your worksheet.

## Bottom Line:

In this article, you can get to know all the **formulas to find a date & time calculations** in Excel Office 365. Kindly, drop **feedback** in the **comment** box. Thank you for visiting **[Geek Excel](https://geekexcel.com/)!!**