Рет қаралды 538
Learn multiple ways to calculate age from birth date. Use #datedif #function in #excel and #powerbi
Download files from here
efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:06 - Simple formulas
02:04 - LET function
02:47 - Datedif variation
03:24 - Handling zeros
03:46 - DAX formula
04:36 - Sort By column
Related videos 📺
Merged rows - Data Clean up - Excel Power Query - • Merged rows - Data Cle...
How to remove excess formatting in Excel - improve performance - • How to remove excess f...
Handle millions of rows in Excel - Large slow files? - use Data Model - • Handle millions of row...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)