Monday, 2 January 2012
Excel Do Easy: Age calculation using DATEDIF function.
Excel Do Easy: Age calculation using DATEDIF function.: How To Calculate Your Age :- The Excel DATEDIF function helps you to calculates the Age, tenures & difference between two dates. It can ...
Age calculation using DATEDIF function.
How To Calculate Your Age :-
The Excel DATEDIF function helps you to calculates the Age, tenures & difference between two dates. It can show the result as number of Days, Months & Years.
Syntax : -
=DATEDIF(date1, date2, Interval)
The DATEDIF function syntax has the following arguments : -
date1 :- It is the first date and it must have the earliest date between the two date.
date2 :- It is the second date and must be the recent or today of the two dates.
Interval :- This is the interval type that indicates what you want to view such as [Days, Months & Years].Interval Type must be "D" to view Days, "M" to view Months of "Y" to view Years
Example :-
Follow me on :-
http://exceldoeasy.weebly.com/
The Excel DATEDIF function helps you to calculates the Age, tenures & difference between two dates. It can show the result as number of Days, Months & Years.
Syntax : -
=DATEDIF(date1, date2, Interval)
The DATEDIF function syntax has the following arguments : -
date1 :- It is the first date and it must have the earliest date between the two date.
date2 :- It is the second date and must be the recent or today of the two dates.
Interval :- This is the interval type that indicates what you want to view such as [Days, Months & Years].Interval Type must be "D" to view Days, "M" to view Months of "Y" to view Years
Example :-
Follow me on :-
http://exceldoeasy.weebly.com/
Subscribe to:
Posts (Atom)