DD MM YYYY Excel Age Formula Generator

📋 DD MM YYYY Excel Age Formula Generator — Generates formula for DD-MM-YYYY text dates

Copy the generated formula or embed snippet into your spreadsheet or website.

What This Calculator Does ✨

This tool generates ready-to-use output such as spreadsheet formulas or embed code. Copy the result into Excel, Google Sheets, or your own website.

You will fill in: DOB text cell, Separator type. Each field is clearly labeled so mistakes are less likely. ✅

Why generate formulas here?

Building spreadsheet formulas from scratch invites typos. Generate a tested pattern here, then paste it into your workbook.

Tips for Accurate Results ✅

• Use four-digit years (1990, not 90).
• Choose the month from the dropdown to avoid US/EU format confusion.
• For “age on” tools, enter the event date—not today—unless the label says otherwise.
• Save or print the result when a government or school form requires proof.

Who is this page for?

Teachers, genealogists, and office staff who answer the same date question for others throughout the week.

How to use the DD MM YYYY Excel Age Formula Generator 📝

• Find the DD MM YYYY Excel Age Formula Generator form in the left column of this page.
• Fill in: DOB text cell, Separator type.
• Copy the generated formula or embed code to a text file before you close the tab.
• Press Calculate and wait for the result panel to update.
• Copy, screenshot, or write down the answer if you need it for a form.

Examples 📊

Here are two sample runs. Your real dates will give your own personal result.

Example 1

Input: DOB text in A2: 15-05-2000

Output: =DATEDIF(DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)),TODAY(),”Y”)

Example 2

Input: DOB: 01-01-2018; Target: 01-06-2026

Output: 8 years, 5 months

DD MM YYYY Excel Age Formula Generator — common questions ❓

Each question below refers to this calculator by name and to the fields on its form.