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, duration hours minute second in high quality that is uploaded to the channel INFOTAINMENT 30 November 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 52 times and liked it 0 visitors.