- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to calculate the percentage between two dates in Excel?

Calculating a percentage in mathematics requires performing the operation of "multiplying the fraction by one hundred." The origin of the word "percent" can be traced back to Latin, when it was originally written as "per-cent." Take for instance the fact that you are now enrolled in a college that offers a total of six topics. You are required to complete an exam for each topic, and there is a possible score of 100 points available for each topic. The aggregate score for all of the topics covered adds up to a total of 600 points.

Let's say out of 600 points, you got 460. You should now determine the average of all of your results. To determine your position in relation to others, divide your score by the total number of marks on the quiz, then multiply the resulting fraction by 100.That is to say -: (475/600)*100 = 76.66. Your response makes it very evident that you currently hold a score of 76.66 percent overall.

In a same vein, there are a variety of circumstances in which you can be required to determine the percentage of one or more of the several parameters included in your Excel Datasheet.

Suppose we have a list of tasks with start dates and finish dates. at this point, we want to determine the percentage of tasks that have been completed based on today's date. Let’s learn how to perform this task In excel.

## Step 1

We have Start date and end date of some projects as shown in below given image. We have to calculate the percentage of completion of the project.

## Step 2

Then select one blank cell and the below given formula in formula bar. In our case we have selected the cell D2 and added the below given formula in it.

=(DATEDIF(B2,TODAY(),"d")+1)/(DATEDIF(B2,C2,"d")+1)

In our example, we are comparing for the cell B2 and C2. You can change it as per your need. After adding the formula press enter to see the result.

See the below given image.

## Step 3

After that, if you pull the fill handle all the way down to the cells where you want to apply this formula, you will achieve the desired outcome. See the below given image.

## Step 4

After applying the formula you will get the value as of General form. To change it to Percentage style, select the cells containing the formulas and then click **Percentage** Style in the **Home** tab's **Number** group.

See the below given image.

Then you will get values as percentages. See the below given image.

## Conclusion

In this tutorial, we used a simple example to show how you can calculate the percentage between two dates in Excel.

- Related Articles
- How to calculate the midpoint between two dates in Excel?
- How to calculate average between two dates in Excel?
- How to calculate the weeks and days between two dates in Excel?
- How to list all dates between two dates in Excel?
- How to calculate the difference between two dates in JavaScript?
- How to calculate minutes between two dates in JavaScript?
- Calculate the difference between two dates in days, weeks, months and years in Excel
- How to calculate percentage of total in Excel?
- Calculate minutes between two dates in C#
- How to calculate time difference between two times or dates?
- How to calculate the percentage of year or month passed in Excel?
- How to calculate the absolute difference between two values/times in Excel?
- How to Calculate the Percentage of Yes and No from a List in Excel?
- How can I calculate full 24hour days between two specified dates in MySQL?
- How do I calculate number of days between two dates using Python?