AGE Calculator in MS Excel
In MS Excel there are many formula to calculate age, but i am explaining here very simple and quick formula for you.you just note down and practice in Excel
Step By Step instructions
Step no.1
- Create statement in excel, start your work from A1
- in A1 type Heading Date of Birth, in B1 type Current Date, in C1 type Age, in D1 type Months
- in E1 type Day of week, in F1 type Days, in G1 type My Age is and in H1 type Bithday Reminder
Step no.2
- in A2 use following statement
=DATE(1971,7,28) or enter your date of birth using this format =Date(year,month,day) and press Enter key - in B2 use Today(0 function type this=today()
- in C2 type this
=DATEDIF(A2,B2,"Y") and press Enter
Y means you want to calculate no of years. - In D2 type this
=DATEDIF(A2,B2,"YM")
YM means you want to calculate remaining months - in E2 type this
=CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday",
"Saturday")
this formula return us Day of birth in character - in F2 type
DATEDIF(A2,B2,"MD")
this formula return us remaining days of your age - in G2 type
=C2& " yrs. "&D2&" Months "& F2 &" Days old"
this formula summarize all previous columns in to single cell - in H2 type
=IF(AND(MONTH(A2)=MONTH(B2),DAY(A2)=DAY(B2)),"happy birthday","")
if current date column is your date of birth, then this column shows your date of birt as reminder
No comments:
Post a Comment