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.
Here's how to calculate tenure in Google Sheets using the formula above:
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)
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.
Note: Ensure your dates are in a format recognized by Google Sheets (e.g., MM/DD/YYYY or DD/MM/YYYY).
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.
Here's the final output:
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.
