In this Excel video tutorial, let's see how to calculate age in Excel, how to calculate years in Excel, how to calculate the difference between one date to another in Excel, age calculation in Excel, calculation of years in Excel, formula to calculate years , function to calculate age.

the basic formula for calculating values in Excel is today's date minus the date of birth divided by 365, that is, the number of days in a year, but the problem with doing it this way is that not every year has 365 days, for example, the year leap year and in these cases our account will not be accurate

a function that can help us to calculate ages in excel is the datedif function, this formula in excel is a very important formula but it is not listed along with the other important formulas in excel

to use the if date function in the Excel spreadsheet we can first select the date of birth semicolon today's date semicolon and put What type of return do we want as a result the difference in years the difference in months or the difference in days between one date and another

an interesting tip to leave our automated function in Excel is instead of using today's date writing manually manually typing today's date today we can instead use the today function in Excel because the today formula in Excel will always return today's date no matter when you open your Excel spreadsheet it will always return today's date according to your computer's date

#JopaExcel #Dashboard #Excel