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)`