Skip navigation
The DATEDIF function is a hidden feature in Excel it won’t appear in suggestions, but it works…
0:00

The DATEDIF function is a hidden feature in Excel it won’t appear in suggestions, but it works…

The DATEDIF function is a hidden feature in Excel it won’t appear in suggestions, but it works perfectly! This formula calculates a person’s age automatically based on their date of birth. B2 → the cell containing the date of birth TODAY() → returns the current date "Y" → tells Excel to calculate the difference in years So Excel finds how many full years have passed between the date in B2 and today’s date giving you the person’s age instantly. Comment “Course” if you want to master Excel

Comments

Comments from the original post on Instagram

No comments yet