In this example, we would like to calculate the age of all the people listed in the table from data of birth. We can use the function datedif, for the first input, we will pick the cell that contains the date of birth, then we use the function Today(), instead of specifying today’s date in order for it to always compare with today’s date,, now, we put the letter “y” to get the result in years, for months we can put “m”, for days “d”. We close the function then press enter, then we copy the function to the rest of the table.
Social Media Links : https://bio.link/techmab
#excel #exceltutorial #exceltips #tutorial #education