Excel Formulas to Find Last Working Date of a Month ~ Easy Tips!!
Tags: excelformula, excelformulas
Published: 2021-05-18 02:44:41

---
title: Excel Formulas to Find Last Working Date of a Month ~ Easy Tips!!
published: true
date: 2021-05-17 15:28:24 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-last-working-date-of-a-month/
---

Do you know how to find the first or last working day of given month date in a worksheet? While working with Excel, we are able to count only the workdays in any month by excluding the weekends and specified holidays.  This step-by-step tutorial will assist you to **get the last working date of a month in Excel**. 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)

[![Get the last workday of a month](https://geekexcel.com/wp-content/uploads/2021/05/Get-the-last-workday-of-a-month.png)](https://geekexcel.com/excel-formulas-to-find-last-working-date-of-a-month/get-the-last-workday-of-a-month/#main)<figcaption id="caption-attachment-43453">Get the last workday of a month</figcaption>

## Generic Formula:

- You can use the below formula to find out the last working date of a month in Excel.

**=[WORKDAY](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)([EOMONTH](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/)(date,0)+1,-1)**

## Syntax Explanations:

- **WORKDAY** – This function will help to calculate the proximate working day based on the value we provide and returns a number that represents the date. Read more on the [**WORKDAY function**](https://geekexcel.com/how-to-use-workday-function-in-excel-365/).
- **EOMONTH**  – In Excel, the [**EOMONTH function**](https://geekexcel.com/how-to-use-eomonth-function-in-microsoft-excel-365/) helps to return the last day of the month after adding/subtracting a specified number of months to a date.
- **Date**  – It specifies the input values from your worksheet.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol is used to add the values.

## Example:

Let’s consider the below example image.

- Here we will enter the input dates in **Column B**.
- Now we are going to calculate the last working date of the given month.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-34.png)<figcaption id="caption-attachment-43454">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-53.png)<figcaption id="caption-attachment-43452">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-50.png)<figcaption id="caption-attachment-43455">Result</figcaption>

## Bottom-Line:

Here, we have discussed **how to get the last working date of a month in Excel**. Hope you like it. Please feel free to state your **query** or **feedback** for the above article.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Display the Current Date ~ Quick Method!!](https://geekexcel.com/excel-formulas-to-display-current-date/)**
- **[Excel Formulas to Get Fiscal Year From the Date ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-fiscal-year-from-the-date-quick-tricks/)**
- **[How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!](https://geekexcel.com/enter-a-time-in-excel/)**
- **[Excel Formulas to Find the Earliest & Latest Dates From the Given Range!!](https://geekexcel.com/excel-formulas-to-find-the-earliest-latest-dates-from-the-given-range/)**