Formulas to Count Dates by Day of Week in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-11-03 09:03:45

---
title: Formulas to Count Dates by Day of Week in Excel Office 365!!
published: true
date: 2020-11-03 08:22:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-dates-by-day-of-week-in-excel-office-365/
---

In this tutorial, we will explain how to use the **Formulas to count the dates by day of the week in Excel Office 365**. This article will help to count dates by the weekday (i.e. count Monday, Tuesday, Wednesday, etc.). Let’s see them below!! 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)

[![Formula to count dates by day of the week](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/EXCEL_3zuPHqPYOJ.png)](https://geekexcel.com/?attachment_id=16805#main)<figcaption id="caption-attachment-16805">Formula to count dates by day of the week</figcaption>
## General Formula:

- The below formula will help to count the dates by day of the week in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–([WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)(dates)=day\_num))**

## 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.
- **WEEKDAY** – The  [**WEEKDAY Function**](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/) in Excel returns a number (ranging from 1 to 7) that represents the day of the week for a given date. By default, it gives an integer from 1 (Sunday) to 7 (Saturday).
- **Dates** – It represents the input dates given in a worksheet.
- **Day\_Num** –  It is the cell number of the weekdays in your worksheet.
- **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:

- In the below screenshot, we will give the input in **Column B**.
- After that enter the given formula in the selected field.
- Finally, it will display the result as shown in the given image.

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

## Bottom Line:

From this article, you can get some clarification on the **Formulas for counting the dates by day of the week in Excel Office 365** with a suitable example. Hope that this article is useful to you. If you have any suggestions, 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 Ahead:

- [**Formulas for Counting the Cells that are Non-Blank in Excel Office!!**](https://geekexcel.com/formulas-for-counting-cells-that-are-non-blank-in-excel/)
- **[Excel Formulas for Converting Days to Years, Months, and Days!!](https://geekexcel.com/excel-formulas-for-converting-days-to-years-months-and-days/)**
- **[Formula to Find the Most Common or Frequently used Values In Excel!!](https://geekexcel.com/formula-to-find-the-most-common-or-frequently-used-values-in-excel/)**