Excel Do Easy: Create Digital Clock On Excel

Excel Do Easy: Create Digital Clock On Excel: =TEXT(HOUR(NOW()),"00")&":"&TEXT(MINUTE(NOW()),"00")&":"&TEXT(SECOND(NOW()),"00") You can create a clock in Excel 2003,2007,2010 in one or a...

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/