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

Subscribe to Blog

Join 1,750 other subscribers

Popular articles

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.