In this post you will learn how to calculate the percent of year completed and remaining in Excel.
Calculating the percent of year completed and remaining –
When building Excel reports and dashboards, oftentimes it’s beneficial to calculate the per-
cent of the year that has elapsed and what percent remains. These percentages can be used
in other calculations or simply as a notification for your audience.
Figure below shows a sample of this concept. Note in the Formula bar that we are using the
YEARFRAC function.
The YEARFRAC function simply requires a start date and an end date. Once it has those two
variables, it calculates the fraction of the year representing the number of days between
the start date and end date.
=YEARFRAC(B3,C3)To get the percent remaining, as shown in cell C7 of the above Figure , simply subtract 1 from the YEARFRAC formula:
=1-YEARFRAC(B3,C3)