﻿ calculating your age in months days and years

# calculating your age in months days and years

aintNoOfMonths adtCurrentDate.Month - adtDateOfBirth.Month aintNoOfYears adtCurrentDate. Year - adtDateOfBirth.YearThe logic is calculating the age as 13 days instead of 14. MsgBox("Your age as on " Format(Now, "dd-MMM-yyyy") vbCrLf years " Years, " months " Months and " days " Days").Find Age in sql server in Year Month Day Format. How to calculate Age using C. age calculation in asp.net c. The Age Calculator can determine the age or interval between two dates. The calculated age will be displayed in years, months, weeks, days, hours, minutes, and seconds. The tutorial shows different ways to get age from birthday in Excel. You will learn a handful of formulas to calculate age as a number of complete years, get exact age in years, months and days at todays date or a particular date. Calculating an age is a common task when working with dates. If you want to figure out the number of years and months between two dates, youll appreciate the discussion in this tip.

Calculate Your Current Age with the Excel DATEDIF Function. Share. Flipboard.In the following formula, the DATEDIF function is used to determine a persons current age in years, months and days. Age Calculator - Know your age in years, months, weeks, days, hours, minutes and seconds! Date of Birth. Similarly I can do to get number of months and number of years. But I want to display all together as years:months:days in one field. I think I need to write PL/SQL but I dont have quite right direction.Plz help!!! To find my age in months, we multiply 13 by 12 because there are 12 months in ayear and I have been around for 13 years.