Calculating Age in Years, Months, and Days altogether in excel
To calculate numbers of complete years: =DATEDIF(B2,TODAY(),"Y")
To calculate the numbers of remaining months: =DATEDIF(B2,TODAY(),"YM")
To calculate the numbers of remaining days: =DATEDIF(B2,TODAY(),"MD")
For more please watch the video for calculator age in excel
Watch video How to Calculate Age in Excel online without registration, duration hours minute second in high quality. This video was added by user INFOTAINMENT 30 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 52 once and liked it 0 people.