Time Count/Calculation using Excel

Microsoft Excel Tips

A: How old are you?
B: I am 38 years old, 11 months and 28 days
A: Wow!.. how do you know exactly your date of birth count from now?.
B: I am using Excel.. :)

Ok, above conversation just an example, you can easily to calculation time by year, months or day using Datedif function in excel.

You cannot find Datedif function in list of excel function, even this function “hiding” from list function but this function very useful for time calculation.

See the example below:
You’re birth of date is 12/5/1970 and present date is 12/2/2009
Use this function below to know the time by year, month and day :

=DATEDIF(Date1,Date2,Interval)



Another option for interval :
1. “m”= To count date by Month.
2. “d” =to count date by day.
3. “y” = to count date by year
4. “ym” = to count Month without the year
5. “yd” = to count day without year
6. “md” = to count day without year and month

You can try each interval option to more understand how to use it.

Related Topics:
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
Easy way to copy one cell to a lot of cells in Excel
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Time Count/Calculation using Excel
Microsoft Excel 2007: How to take limit value to the cell