excel difference between two dates
Posted on 2010-08-28
Ok then a simple question very difficult answer I find...
I have two dates in columns 01/01/2004 and 31/12/2010, and as any sensible person would say this is seven years which equates to 7 * 12 = 84 months. So why does excel =Datedif(c1,c2,"m") compute 83? Actually why does excel datedif also compute the above dates as 6 years (=Datedif(c1,c2,"y")).
The crux of the matter is how do I get the true duration (in months) between two dates?