Download the very amazing age calculator designed by techguruplus.com
here in this calculator you just have to enter the date of birth of any person and you will get the result as Age in Years, Age in months, Age in Days, hours, minutes, seconds also in milliseconds, with date day as birth.
Nazim Khan — Founder & Editor, TechGuruPlus.com
[MBA in Finance]
Nazim Khan has spent over ten years working with Excel, Tally and office documentation in accounts, finance and MIS roles. He has been running TechGuruPlus.com since 2016, where he publishes free editable templates for office work, and the YouTube channel Business Excel. He has trained more than 50,000 people online. Every template on this site is built and checked by him before it is published.
Sir, for age in years, we can also use this formula to get the desired result =YEARFRAC(D5,TODAY(),1) and for age in month, we can simply multiply the same by 12. Further, I have used this formula to get the months =YEARFRAC(D5,TODAY(),1)*12, result is coming 384.63 and your result Age in months is 384.65. I want to know why this difference is coming in values and which is the right answer.
nadim aap ko excel ka accha knowladge hai
GOOD
Sir, for age in years, we can also use this formula to get the desired result =YEARFRAC(D5,TODAY(),1) and for age in month, we can simply multiply the same by 12. Further, I have used this formula to get the months =YEARFRAC(D5,TODAY(),1)*12, result is coming 384.63 and your result Age in months is 384.65. I want to know why this difference is coming in values and which is the right answer.
Good sir
Sir, I want to lead the Excel formula maintain the sheet, and create a also dashboard