FormulaCraft

TODAY / DATEDIF

Work with the current date and measure the gap between two dates.

TODAY returns the current date; DATEDIF measures the difference in days, months, or years — useful for ages and tenure.

Excel
=DATEDIF(A2, TODAY(), "Y")
Google Sheets
=DATEDIF(A2, TODAY(), "Y")

How it works

  1. 1A2 is the start date.
  2. 2TODAY() is the end date.
  3. 3"Y" returns whole years between them.

Need a version for your data?

Try: “Calculate how many full years between the date in A2 and today”