Formulas for Counting the Dates from a given Year in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-03 09:03:19

---
title: Formulas for Counting the Dates from a given Year in Excel!!
published: true
date: 2020-11-03 08:10:45 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-the-dates-from-a-given-year-in-excel/
---

This page will explain the **Formulas for counting the dates from a given year in Excel Office 365** with basic syntax and a suitable example. 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 count dates form a given year](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-dates-form-a-given-year.png)](https://geekexcel.com/formulas-for-counting-the-dates-from-a-given-year-in-excel/formulas-to-count-dates-form-a-given-year/#main)<figcaption id="caption-attachment-16788">Formulas to count dates form a given year</figcaption>
## General Formula:

- Use the following formula to count the dates from a given year in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(dates)=years))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, the [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) will multiply the corresponding array or range and returns the sum of the products.
- **YEAR** – This function helps to get the year from a given date. Read more on the [**YEAR Function**](https://geekexcel.com/how-to-use-year-function-in-excel-365/).
- **Dates** – It represents the input dates given in a worksheet.
- **Years** –  It is the criteria that are used to count the dates.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Minus operator (-)** – This symbol is used to subtract any two values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Let’s consider the example image to count the dates from a given year.
- First, you need to enter the input dates in MM/DD/YY format.
- Then enter the given formula in the selected area.
- After applying the formula, you can get the result as shown below.

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

## Wind-Up:

In this tutorial, we explained the **formulas to count the dates from a given year in Excel Office 365**. Hope that this article is useful to you. If you have any queries, feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Formulas for Counting the Times a Word Appears in a Cell in Excel!!](https://geekexcel.com/formulas-for-counting-the-times-a-word-appears-in-a-cell-in-excel/)**
- [**Excel Formulas to Reverse Order of Characters in a Cell with Functions!!**](https://geekexcel.com/excel-formulas-to-reverse-order-of-characters-in-a-cell-with-functions/)