<\/p>\n
What does it do? <\/strong><\/em><\/p>\n Calculates the number of Days, Months, or Years between two dates<\/p>\n Formula breakdown: <\/strong><\/em><\/p>\n =DATEDIF(Start Date<\/span>,End Date<\/span>,Interval<\/span>)<\/p>\n What it means:<\/strong><\/em><\/p>\n =DATEDIF(starting date<\/span>, ending date<\/span>, the unit of measuremen<\/span>t)<\/p>\n Where INTERVAL<\/strong> is:<\/p>\n “m<\/strong>” Months , “ym<\/strong>” Months Excluding Years The DATEDIF<\/strong> function is a mystery function within Excel.\u00a0 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…<\/p>\n The DATEDIF<\/strong> function stands for “date difference<\/strong>” and it calculates the number of Days, Months, or Years between two dates.<\/p>\n 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!\u00a0\u00a0 Well you can also extend this to project start and end dates, but you get my point.<\/p>\n
\n“d<\/strong>” Days , “yd<\/strong>” Days Excluding Years
\n“y<\/strong>” Years , “md<\/strong>” Days Excluding Years And Months<\/p>\n
\n