How to Find Difference bt two Dates | Calculate your age in Years, Months, Days | Excel Formula

How to Find Difference bt two Dates | Calculate your age in Years, Months, Days | Excel Formula |

Namaskar doston aaj ke iss video mein ham aapke liye lekar aaye hai ek eshi sandar excel ki formula trick jiski madad se aap koi bhi do dates ke beech ka antar asani se nikal sakte hai or sath hi sath apni age bhi year, month ya phir days mein calculate kar sakte hai.

To find difference between two dates here is the formula : =DATEDIF(Cell number 1,Cell number 2 ,"Y") in Years Ex : =DATEDIF(C5,D5,"Y")
To find difference between two dates here is the formula : =DATEDIF(Cell number 1,Cell number 2 ,"YM") in Months Ex: DATEDIF(C5,D5,"YM")
To find difference between two dates here is the formula : =DATEDIF(Cell number 1,Cell number 2 ,"MD") in Days Ex: DATEDIF(C5,D5,"MD")

To find your exact age in years, months and days is
=DATEDIF(I5,TODAY(),"Y")

Our Social Platforms :

Some of the equipments I use

Title Tags:
How to calculate age online,
how to calculate age in excel,
how to calculate age in years,
how to calculate age in months,
how to calculate age in days,
how to find difference between two dates,
ab apni age calculate kare sirf 1 minute,
Calculate your age in years months days,
technology with vivek,
vivek bhardwaj,
excel formula,
MS excel,
MS excel today formula,
How to Find Difference bt two Dates,
age kese nikale,
years month mein age kese nikale online,
umar nikalana sikhe,
online hamari umar kese nikale,
online hamari age kese nikale,

#technologywithvivek
#Excelformulas