How to Calculate Age in Excel with Number of Years Months and Days
If you want to calculate Age with number of years, months and days in Excel, this tutorial got you cover. This excel tutorial in khmer explain the DateDif formula along with example demo.
DateDif in Excel
The Excel DATEDIF function is used to returns the difference between two date values in years, months, or days.
DateDif Formula
◾ end_date: Required, end date you want to calculate.
◾ Format: required
- "y" Difference in complete years
- "m" Difference in complete months
- "d" Difference in days
- "md" Difference in days, ignoring months and years
- "ym" Difference in months, ignoring years
- "yd" Difference in days, ignoring years
Download Example Excel File below
Join My Special Courses To Level Up Your Skills: 👉 UP SKILLS 👈
⚡Free Download Khmer Books PDF
⚡Telegram: ReanComputer101
If you want to calculate Age with number of years, months and days in Excel, this tutorial got you cover. This excel tutorial in khmer explain the DateDif formula along with example demo.
DateDif in Excel
The Excel DATEDIF function is used to returns the difference between two date values in years, months, or days.
DateDif Formula
=DATEDIF (start_date, end_date, format)
◾ start_date: Required, start date you want to calculate.◾ end_date: Required, end date you want to calculate.
◾ Format: required
- "y" Difference in complete years
- "m" Difference in complete months
- "d" Difference in days
- "md" Difference in days, ignoring months and years
- "ym" Difference in months, ignoring years
- "yd" Difference in days, ignoring years
Download Example Excel File below
Join My Special Courses To Level Up Your Skills: 👉 UP SKILLS 👈
Useful Links
⚡Learn Code Khmer (HTML, CSS, JavaScript, ReactJS, PHP,...)⚡Free Download Khmer Books PDF
⚡Telegram: ReanComputer101