=DATEDIF(A1,B1,"Y") — full years between dates. For complete breakdown: Years: =DATEDIF(A1,B1,"Y"), Months: =DATEDIF(A1,B1,"YM"), Days: =DATEDIF(A1,B1,"MD"). DATEDIF is a hidden Excel function — type it manually; it won't appear in autocomplete but it works.

Class 1: 6 years by 31 March or 1 June depending on state. KG/LKG: 3.5–4 years on cut-off date. Enter your child's DOB and the school's cut-off date to get exact age. Different states and schools have different cut-off dates — always verify with the specific school.

Must be 18 years on 1 January of the electoral roll revision year (the Election Commission announces qualifying dates). Enter your DOB and 1 January of the next election year to check eligibility.

Enter your date of birth and the event date as the target date. The result shows your exact age in years, months and days on that specific date — useful for commemorative purposes or verifying certificates.