# How To Get The Percent Of The Month Completed

## Example

=DAY(B3)/DAY(EOMONTH(B3,0))

## Generic Formula

=DAY(Date)/DAY(EOMONTH(Date,0))
Date – This is the date on which you would like to calculate the percentage of the month completed.

## What It Does

This formula will return the percent of the month completed for a given date.

## How It Works

DAY(Date) will return the day part of the given Date. In our example DAY(“2017-09-10”) returns a value of 10.

EOMONTH(Date,N) will return the last date in the month which is N number of months before or after the Date. If N is 0 then this will be the last date in the same month as the given Date. In our example, EOMONTH(“2017-09-10”,0) results in “2017-09-30” because this is the last date in the month of September. We then use the DAY function to return the numerical value of the last day of the month. In our example DAY(“2017-09-30”) results in the value 30.

We then get the percentage of the month completed by dividing the day part of the given Date by the day part of the last date in the month. In our example, this is 10/30 which results in 33.3%.

## John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

## Related Articles

#### How To Conditionally Concatenate A Range

This formula will conditionally concatenate a range based on a criteria in another range.

#### How To Solve a Quadratic Equation

These formulas will give the solutions to a quadratic equation.

#### How To Select A Random Item From A List

This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.