If you have ever wondered how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone’s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built‑in functions that make this process simple, accurate, and flexible — without needing any extra tools.
To begin, you will need a cell containing the birth date. For example, suppose cell A2 contains the date of birth. One of the most accurate ways to calculate age is by using the DATEDIF function, which compares two dates and returns the difference in years, months, or days. For age calculation in years, you can type:
=DATEDIF(A2, TODAY(), "Y")
This formula checks the date in A2 against the current date and calculates the full years between them. The reason DATEDIF works so well is that it takes leap years and month differences into account, giving you a precise result.
If you want to show the age in a more detailed way, such as “25 years, 3 months”, you can combine multiple DATEDIF functions like this:
=DATEDIF(A2, TODAY(), "Y") & " years, " & DATEDIF(A2, TODAY(), "YM") & " months"
Google Sheets also allows you to format the output or use conditional formatting to highlight certain age ranges, which is especially helpful for HR departments or school administrators. Another advantage is that you can copy and paste these formulas across rows to calculate the age for multiple people at once without having to redo the work.
Accuracy matters when dealing with date calculations, so it is important to ensure your date of birth cells are in proper date format and not stored as text. You can check this by selecting the cell and setting the format to Date under the Format menu. Keeping the data clean ensures your formulas produce the right results every time.
Knowing how to calculate age in Google Sheets can save a lot of time and reduce human error compared to manual calculation. Whether you’re building a personal spreadsheet, running a school database, or managing employee information, mastering this skill will make your data work smarter and faster.
