How To Get The Percent Of The Month Completed

Example

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

Download Example File

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%.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.