Excel Formulas to Calculate the Average Time per Month!!
Tags: excelformula, excelformulas
Published: 2020-12-07 10:54:17

---
title: Excel Formulas to Calculate the Average Time per Month!!
published: true
date: 2020-12-07 09:57:13 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-average-time-per-month/
---

Here, we will guide you to learn the simple **formulas used to calculate the average time per month in Excel Office 365**. Let’s get into this article!! 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)

[![Formulas to get the average time per month](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-get-the-average-time-per-month.png)](https://geekexcel.com/excel-formulas-to-calculate-the-average-time-per-month/formulas-to-get-the-average-time-per-month/#main)<figcaption id="caption-attachment-18850">Formulas to get the average time per month</figcaption>
## General Formula:

- To get the average time per month in Excel, use the below formula.

**=[AVERAGEIFS](https://geekexcel.com/how-to-use-excel-averageifs-function-in-office-365-with-examples/)(durations,dates,”>=”&A1,dates,”<=”&[EOMONTH](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/)(A1))**

## Syntax Explanations:

- **AVERAGEIFS** – This function returns the average of a set of input values that meet the multiple criteria. Read more on the [**AVERAGEIFS Function**](https://geekexcel.com/how-to-use-excel-averageifs-function-in-office-365-with-examples/).
- **EOMONTH** – In Excel, the [**EOMONTH Function**](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/) will help to return the last day of the month after adding/subtracting a specified number of months to a date.
- **Durations** – It is calculated by subtracting the date opened from the date closed.
- **Dates** – It is the input dates from your worksheet.
- **Criteria (A1)** – It specifies the month that help to get the average.

## Example:

- Let’s consider the below image, to get the average time per month in Excel.
- First, we will give the input ranges in **Column B** , **Column C** , **Column D**.
- After that, enter the given formula in the formula bar section.
- Finally, it displays the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-30.png)<figcaption id="caption-attachment-18853">Example</figcaption>

## Wrap-Up:

This page explained the simple **formula used to calculate the average time per month in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** kindly leave it in the below comment section. To know further updates keep in touch with our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Sum columns based on Adjacent criteria!!](https://geekexcel.com/excel-formulas-to-sum-columns-based-on-adjacent-criteria/)**
- **[Excel Formulas to Sum the Values Between two Numbers!!](https://geekexcel.com/excel-formulas-to-sum-the-values-between-two-numbers/)**