November 5, 2024

How to get age from birthday in years, months and days ? #exceltricks #excel #exceltips

Video by Digital E-Learning via YouTube
Source

How to get age from birthday in years, months and days ? #exceltricks #excel #exceltips. If you want to know the exact age, i.e. how many years, months and days there are between someone’s birth date and the current date, write 3 different DATEDIF functions:

1) For number of years use =DATEDIF(C3, TODAY(), "Y")
2) For number of months use =DATEDIF(C3, TODAY(), "YM")
3) For number of days use =DATEDIF(C3,TODAY(),"MD")

𝐅𝐨𝐫𝐦𝐮𝐥𝐚𝐞 =DATEDIF(C3,TODAY(),"Y")& " Years, " & DATEDIF(C3,TODAY(),"YM") & " Months, " & DATEDIF(C3,TODAY(),"MD") & " Days"

🎥 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐦𝐲 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥 : http://www.youtube.com/DigitalELearning

📢📢 📢📢 𝐅𝐨𝐥𝐥𝐨𝐰𝐬 𝐮𝐬 𝐨𝐧 𝑺𝒐𝒄𝒊𝒂𝒍 𝑴𝒆𝒅𝒊𝒂
————————————————————————-
🐦𝐓𝐰𝐢𝐭𝐭𝐞𝐫 : https://twitter.com/DigitalELEARNI1
📸 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦 : https://www.instagram.com/digital_elearning/
📩 𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦 : https://t.me/digital_e_learning007
🙋🏻‍♂️ 𝐏𝐢𝐧𝐭𝐫𝐞𝐬𝐭: https://in.pinterest.com/digitalelearning007/
🙋🏻‍♂️ 𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧 𝐏𝐚𝐠𝐞: https://www.linkedin.com/company/55180987
🙋🏻‍♂️ 𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤 𝐏𝐚𝐠𝐞 : https://www.facebook.com/DigitalELEARNI1
💌 𝑪𝒐𝒏𝒕𝒂𝒄𝒕 𝒖𝒔 : digital.e.learning007@gmail.com for any business/ promotion queries.

✍️ 𝓓𝓲𝓼𝓬𝓵𝓪𝓲𝓶𝓮𝓻:
Copyright Disclaimer under section 107 of the Copyright Act of 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. The information contained in this video is just for educational and informational purposes only and does not have any intention to mislead or violate Google and YouTube community guidelines or policy. I respect and follow all terms & conditions of Google & YouTube.

𝐂𝐨𝐦𝐦𝐨𝐧 𝐊𝐞𝐲 𝐬𝐞𝐚𝐫𝐜𝐡 𝐫𝐞𝐥𝐚𝐭𝐞𝐝 𝐭𝐨 𝐭𝐡𝐢𝐬 𝐭𝐨𝐩𝐢𝐜 :
———————————————————————-
#Digital_e_Learning #ifformulainexcel #basicexcel #exceltutorial #excelforbeginners #exceltips #exceltricks #exceltraining #exceltutor #msexceltipsandtricks #msexcel #excelbasicsintamil

Go to Source