fbpx

Calculate age from birth date or joining date

Learn multiple ways to calculate age from birth date with the Dated If function in Excel and Power BI with a sample file to use.

Download files from here

Contents

  1. Intro – 00:00
  2. Simple formulas – 00:06
  3. LET function – 02:04
  4. Datedif variation – 02:47
  5. Handling zeros – 03:24
  6. DAX formula – 03:46
  7. Sort By column – 04:36

Merged rows – Data Clean up – Excel Power Query

How to remove excess formatting in Excel

Handle millions of rows in Excel – Large slow files? – use Data Model

Queries | Comments | Suggestions | Wish list