Shorts 10 DATEDIF English
DATEDIF is used to calculate the period between two dates.
What?😨 Does it has some real life application, also ?🤔
Yess. It is used to calculate the age of the person. 🤓
But how it is calculated?👨💻
To calculate age we will use DATEDIF along with TODAY function.
As we all know that TODAY function in Excel helps in getting today's date.
The formula we use here is =DATEDIF ("Date of birth",TODAY(),"Y")
After typing formula we press enter and age is calculated.
To understand better please watch this one minute short video.
#excel #excelcareerhub #datedif #today #shortcuts #learninganddevelopment #excelveer
To learn by practicing with the video please download Excel File by clicking on link.
https://docs.google.com/spreadsheets/...
Link will open Google sheet, there please click on File and then select download as .xlsx to get Excel file.