Excel Formulas to Get the End Date of the Project Based on a Criteria!!
Tags: excelformula, excelformulas
Published: 2021-05-20 08:03:46

---
title: Excel Formulas to Get the End Date of the Project Based on a Criteria!!
published: true
date: 2021-05-19 14:31:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-the-end-date-of-the-project/
---

Assume that you have to handle 8 projects at a time. While preparing reports, you are required to track the end date of the project. How can you calculate them quickly? Today, I will introduce some quick ways to **get the end date of the project based on certain criteria in Excel**. Let’s get 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)

[![Find end date of the project](https://geekexcel.com/wp-content/uploads/2021/05/Find-end-date-of-the-project.png)](https://geekexcel.com/excel-formulas-to-get-the-end-date-of-the-project/find-end-date-of-the-project/#main)<figcaption id="caption-attachment-44101">Find the end date of the project</figcaption>

## General Formula:

- To find out the end day of the project you can use the below formula.

**=[WORKDAY](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)(start,days,holidays)**

## Syntax Explanations:

- **WORKDAY** – The [**WORKDAY Function**](https://geekexcel.com/how-to-use-workday-function-in-excel-365/) calculates the proximate working day based on the value we provide and returns a number that represents the date.
- **Start** – It represents the starting date from your worksheet.
- **Days** – It specifies the number of days.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input dates in **Column B** , **Column C** , and **Column D** which specifies the **project name** , **starting date** of the project, and the **number of days** allocated for the project.
- Now we are going to find out the ending date of the project excluding the holidays which is given in **Column E**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-38.png)<figcaption id="caption-attachment-44102">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-64.png)<figcaption id="caption-attachment-44100">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-60.png)<figcaption id="caption-attachment-44099">Result</figcaption>

## Conclusion:

Hope you like this article on **how to find the end date of the project in Excel**. I hope this helps. Feel free to ask back any **questions** and let us know how it goes.

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 Ahead:

- **[Excel Formulas to Find a Nth Day of Week in a Month ~ East Tricks!!](https://geekexcel.com/excel-formulas-to-find-a-nth-day-of-week-in-month/)**
- **[Excel Formulas to Get the Nth day of Year ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-get-the-nth-day-of-year/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Extract the Month From Date ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-extract-the-month-from-date/)**