The DATEDIF function is a mystery function within Excel.  When you write it out in a workbook it doesn’t give you any hints like other functions would and if you look it up in the function list you would not find it! Creepy…

The DATEDIF function stands for “date difference” and it calculates the number of Days, Months, or Years between two dates.

So if you want to find out how many days, years or months have passed since you were born, well this is the formula for you!   Well you can also extend this to project start and end dates, but you get my point.



Helpful Resource:

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

IF Function Combined With The AND Function When combining (or nesting) the AND function with the IF function, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself. So you can show the results of Sales Reps that have made more than $3,000 of sales AN...
MATCH Function Intro The MATCH function in Excel returns the position of an item within a list or a range of cells. Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function. Formula Breakdown: MATCH...
Jump To A Cell Reference Within An Excel Formula When writing, editing or auditing Excel formulas you will come across a scenario where you want to view and access the referenced cells within a formula argument. This is helpful if you want to check how the formula works or to make any changes to the formula. There is ...
Calculate Total Sales With An Array Formula An Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data.  This could be a range of cells, a worksheet reference or a defined name. One of the most popular uses of an array formula is to calculate Total Sales. ...