Excel Formulas to Get the Midpoint of the Project ~ Easy Tricks!!
Tags: excelformula, excelformulas
Published: 2021-05-20 08:03:24

---
title: Excel Formulas to Get the Midpoint of the Project ~ Easy Tricks!!
published: true
date: 2021-05-19 14:52:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-the-midpoint-of-the-project/
---

So far we have learned how to **[get the end date of the project](https://geekexcel.com/excel-formulas-to-get-the-end-date-of-the-project/)**. In case, you need to find the middle date of the project how can you find it. Here, we will provide some cute formulas to **find out the midpoint of the project date in Excel**. Let’s step 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 Midpoint of the Project](https://geekexcel.com/wp-content/uploads/2021/05/Get-midpoint-of-project-date.png)](https://geekexcel.com/excel-formulas-to-get-the-midpoint-of-the-project/get-midpoint-of-project-date/#main)<figcaption id="caption-attachment-44111">Get the Midpoint of the Project</figcaption>

## Generic Formula:

- You can use the below formula to get the middle date of the project.

**=[WORKDAY](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)(start,days/2,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.
- **Division (/)** – It is used for dividing values or numbers.
- **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.

## Example:

Let’s consider the below example image.

- First, we will enter the input ranges in **Column B** to **Column F** that specifies the **Project**  **name** , **starting**  **date** , **ending**  **date** , the total **number**  **of**  **days** , and **holidays**.
- Now we are going to find out the middle date of the project.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-39.png)<figcaption id="caption-attachment-44112">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-65.png)<figcaption id="caption-attachment-44114">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-61.png)<figcaption id="caption-attachment-44113">Result</figcaption>

## Closure:

So yeah guys this is how we can **find the midpoint of the project date in Excel.** I hope it will help you. If you encounter any **issues** , you may tell us in the **comments** below.

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:

- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**
- **[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/)**