- Mar 4
Completed Years in Excel
- Neale Blackwood
- 0 comments
Sometimes you need to know accurate completed years based on a start date and today’s date. Here is a simple formula to calculate that.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
The solution uses an unusual Excel function called DATEDIF which stands for date difference.
The image below has a list of start dates in column A. Column B has a formula that returns the completed years.
The formula in cell B2 is.
=DATEDIF(A2,TODAY(),"y")It has been copied down.
The “y” in the third argument specifies completed years.
In the example dates on or before 24 February will be treated as a full year based on 2026. Whereas dates after 24 February will use 2025 as the year for calculation.