How to Compare Ages Across Your Whole Family

Most age difference calculators compare two people: you enter two birth dates and get one answer. That's fine for "how much older is my brother than me?", but a family isn't two people. As soon as you add grandparents, parents, siblings and cousins, the number of comparisons grows quickly, and doing them one pair at a time means re-typing the same dates again and again.

The number of unique pairs in a group of n people is n × (n − 1) ÷ 2:

A family age calculator takes the whole list at once and does all of those comparisons for you. ToolDrawer's family age calculator has a dedicated Family / Group mode for exactly this.

• A ranking from oldest to youngest, with each person's exact age in years, months and days and their date of birth.
• The age gap between every pair in the group, written as years, months and days (for example "2 yrs, 6 mo, 17 days"), with the older person listed first in each pair.
• Manual entry or file upload. Type names and dates in, or upload a CSV or Excel (.xlsx) file. Downloadable templates are provided for both.
• Each parent's age at every birth. Every row in the age gap table reads like “Sarah was 22 years old when Liam was born”, so you can see how old each parent and grandparent was when each child arrived.
• Ages on any date. Set the optional “Ages as at” date to see how old everyone will be at a wedding, reunion or holiday, or was in an old photo.
• Family insights. The age span from eldest to youngest, combined and average age, the two people closest in age, shared birthdays and same-day births (twins), whose birthday is next and the next milestone birthdays.
• A search box for big groups. Once you have more than 20 people, a filter appears so you can find every pair that includes one name.
• A PDF report with one page per person: their age, total days and weeks alive, where they rank in the group, and their age gap with everyone else marked as "Older by" or "Younger by".
• Privacy by design. Everything, including reading your spreadsheet and building the PDF, happens in your browser. Names and birth dates are never uploaded.

Option 1: Type the names in

1. Open the Family Age Calculator.
2. Enter a name and pick a date of birth for the first person.
3. Click + Add Person for each extra family member.
4. Click Calculate Ages & Compare. You need at least two people.

Option 2: Upload a spreadsheet

For more than a handful of people, a spreadsheet is faster and you can reuse it next year.

1. On the tool page, open File format and templates (under the upload box) and click Download Template (.xlsx) or (.csv), or make your own file with two columns.
2. Put Name in the first header cell and DateOfBirth in the second.
3. Add one person per row. Dates can be written as DD/MM/YYYY (e.g. 15/06/1985) or YYYY-MM-DD (e.g. 1985-06-15). Real Excel date cells work too.
4. Click Upload a CSV or Excel file and pick your file. The names and dates fill into the list automatically, and you can still edit, remove or add people by hand.
5. Click Calculate Ages & Compare. If any date couldn't be read, the tool names those people so you can fix them.

Reading the results

The ranking shows everyone as a card, oldest first (#1). Below it, the age gap list has one row for every pair. Because the older person is always named first, you can read each row as "first person is older than second person by this much".

Click Download PDF to keep a copy. Each person gets their own page, which makes it easy to print a page for each family member or attach it to a family history record.

Here is a fictional family of seven: two grandparents, two parents and three children. Ages are shown as at 24 October 2026; the gaps never change.

Seven people gives 21 pairs. These are the ones a family usually asks about first:

Notice that the gap between a parent and child is also the parent's age on the day the child was born. That makes the pair list handy for family history notes like "Margaret was 26 when Daniel was born".

A spreadsheet for this family would look like this:

The tool uses the calendar method, the same way people count ages in everyday life and official records. It doesn't divide days by 365, which drifts because of leap years and months of different lengths.

1. Count the whole years between the two dates.
2. Count the whole months left over.
3. Count the remaining days. If the starting day doesn't exist in a month (for example the 31st in a 30-day month), that month is treated as complete on the 1st of the following month.

For example, Ava (4 July 2010) and Noah (30 January 2013): 2013 − 2010 is 3 years, but January is before July, so it's 2 years and 6 months to 4 January 2013, then 26 more days to 30 January. Result: 2 yrs, 6 mo, 26 days.

Some edge cases:

• Twins or anyone sharing a birthday show a gap of "Same day".
• Leap-day birthdays. Someone born on 29 February is counted as reaching their next full year on 1 March in non-leap years.
• Duplicates. If the same name and date appear twice (common when lists are merged), the duplicate is ignored automatically.

• Family history and genealogy. Record each relative's age and how old parents were at each birth, then attach the PDF to your family tree notes.
• Reunions and milestone birthdays. See who is the oldest and youngest, who shares a decade, and whose milestone birthday is coming up.
• Sibling spacing. See the exact gap between each of your children at a glance, rather than working it out from birth years.
• Settling "who's older?" among cousins, in-laws or friends, to the day.
• Clubs, teams and classes. Coaches and teachers can paste in a roster to sort members by exact age. For an eligibility cut-off on a specific date, use the tool's Date Difference mode instead, because Group mode measures ages as of today.
• Carers and aged-care planning. Keep an up-to-date list of ages for a whole family when filling in forms.

You can, but it takes some setup. Excel and Google Sheets have a DATEDIF function that gives the difference between two dates:

That works for one pair. For a whole family you need a formula for every combination: 21 for seven people, 45 for ten. You also have to keep the older person first and sort the list yourself. Microsoft also notes that the "md" unit can give inaccurate results in some cases. The family mode does all of this in one step from the same spreadsheet, and you can download a PDF at the end.

Dates of birth are personal information, often used for identity checks, so it's worth being careful about where you type them. The ToolDrawer Age Calculator does every calculation in your own browser. When you upload a CSV or Excel file it's read locally; the file and the names in it are not sent to a server. The PDF is generated on your device too, and it's saved only where you choose to save it.

Nothing you enter is stored, either by ToolDrawer or in your browser. There's no account, no database and no copy kept on the website, and the page doesn't save your list for next time. When you close or refresh the page, the names and dates are gone. (The only thing the page remembers is whether you chose light or dark mode.) You can confirm that nothing is sent by switching off your internet connection after the page has loaded: the family comparison still works.