226
views
views
Age calculation is made simple with excel. Calculating age might be useful in several situations, especially for business operations. An individual's birthday can be calculated by subtracting the date of birth from the current date. This way you can manually determine a person’s age.
Age calculation is made simple with excel. Calculating age might be useful in several situations, especially for business operations. An individual's birthday can be calculated by subtracting the date of birth from the current date. This way you can manually determine a person’s age.
The same technique can be used in excel as well. Say your age is B3 cell, the formula to calculate age is
=(TODAY()-B3)/365. This formula may give decimal values. To conclude to a nearest integer with a round figure, you can use the. To explore various other ways to find the date of birth, visit our website.
For more information visit: https://www.basictutorials.in/age-calculation-formula-in-excel.php