In this article:

How to Calculate Tenure in Google Sheets (2024 Guide)

May 8, 2024

Tenure Formula in Google Sheets

To calculate tenure in years and months, you can use the DATEDIF function. 

This function requires three arguments: the start date, the end date, and the unit of time you're interested in ("y" for years, "m" for months, "d" for days, "ym" for months excluding years, "md" for days excluding months, and "yd" for days excluding years).

For years and months, you can use the following formula.

=DATEDIF(start_date, end_date, "y") & " years, " & DATEDIF(start_date, end_date, "ym") & " months"

Replace start_date and end_date with the appropriate cell references in your sheet.

How to Calculate Tenure in Google Sheets

Here's how to calculate tenure in Google Sheets using the formula above:

Step 1: Prepare Your Data

In two columns, input the start and end dates for which you want to calculate the tenure. Label these columns for clarity. For example, label Column A as "Start Date" and Column B as "End Date".

Let's say you have the following data in your Google Sheet:

Column A: 1/1/2020 (Start Date)

Column B: 12/31/2023 (End Date)

how to calculate tenure in google sheets

Step 2: Use the DATEDIF Function

Click on the cell where you want the tenure to be displayed. This could be right next to the "End Date" column for convenience. For instance, if your dates start from row 2, click on cell C2 to calculate the first tenure.

Type in the DATEDIF function formula:

=DATEDIF(A2, B2, "y") & " years, " & DATEDIF(A2, B2, "ym") & " months"

Press Enter.

calculate tenure in google sheets

Note: Ensure your dates are in a format recognized by Google Sheets (e.g., MM/DD/YYYY or DD/MM/YYYY).

Step 2: Apply the Formula to Other Rows

After entering the formula in the first cell (e.g., C2), you can apply it to other rows. Click on the small blue circle at the bottom right corner of the cell and drag down to fill the formula into the cells below for each corresponding row of dates.

tenure formula in google sheets

Here's the final output:

formula for tenure in google sheets

We hope that this article has helped you and given you a better understanding of how to calculate tenure in Google Sheets. If you enjoyed this article, you might also like our articles on how to apply RANK IF in Google Sheets and how to resolve the issue when your Google Sheets cell won't change color.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->