Retirement Date Calculator in Excel (Free Template)

A free Excel template that computes your retirement date from your birth date and retirement age — with working EDATE, EOMONTH and DATEDIF formulas. No macros, no sign-up.

Download the Excel template (.xlsx)

Free to keep and share. Works in Excel and Google Sheets (upload the file to Drive and open with Sheets).

How to use it

  1. Enter your birth day, month and year in the yellow cells.
  2. Enter your retirement age in years (and months, if you like).
  3. Read your retirement date — on your birthday and at month-end — plus the weekday and days from today.

The formulas inside

  • Retirement date: =EDATE(DATE(B6,B5,B4),B8*12+B9)
  • Last day of the month: =EOMONTH(EDATE(DATE(B6,B5,B4),B8*12+B9),0)
  • Weekday: =TEXT(B11,"dddd")
  • Days from today: =B11-TODAY()

Want to build your own? The retirement date formula page explains each one for Excel, Google Sheets and pen-and-paper.

Related

Found an error? Report it

Frequently asked questions

Is the template really free?

Yes — download it, keep it, share it with colleagues. No account, no payment, no macros phoning home.

Does it work in Google Sheets or LibreOffice?

Google Sheets: yes — upload the .xlsx to Drive and open with Sheets; EDATE, EOMONTH and TEXT all work. LibreOffice Calc: yes, the same functions exist.

Does the template handle leap years?

Yes — EDATE clamps correctly (29 Feb + 60 years lands on 28 Feb in non-leap years), the same rule the site's calculators use.

Can I adapt it for my scheme's rules?

Yes — it's just formulas. Add your scheme's age, or an EOMONTH wrapper for month-end conventions like India's 1st-of-month rule.