This video demonstrates Datedif function in excel . This function can be used to Calculate your age in Excel. This function is basically meant to find difference between two dates. This difference can be in term of years, months or days.
The syntax of datedif() function is : datedif(start_date, end_date, unit)
start_date refers to starting date
end_date refers to ending date
unit refers to what you want to find. There are six values :
1. Y : Difference in complete Years
2. M : Difference in complete Months
3. D : Difference in complete Days
4. MD : Difference in Days ignoring Months and Years
5. YM : Difference in Months ignoring Days and Years
6. YD : Differenc in Days ignoring Years
Learn Computer Basics - • Learn Computer Basics 1.5 h
Watch video Datedif function excel 2021 hindi | Calculate your age in Excel | Datedif formula excel 2016 hindi online without registration, duration hours minute second in high quality. This video was added by user Lovejot Bhardwaj 27 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 82 once and liked it 2 people.