How to Calculate Age from Present Date in Microsoft Excel

Assalamu Walaikum,

in this video, I will show you, How to Calculate Age from the Present Date in Microsoft Excel. let's get started. firstly format the cell and type your date of birth. type your formula =DATEDIF(C3,TODAY(), "y") & " year " & DATEDIF(C3,TODAY(), "ym") & " month " & DATEDIF(C3,TODAY(), "ym") & " days "

and press enter. now I will calculate the month and date copy the formula and type and paste the formula, y m month, copy the formula again type and paste, days. now I will create a space between the letter. now press the plus button and move the bellow

I hope you enjoyed this video thanks for watching

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email