tag:blogger.com,1999:blog-1869924468172210809.post9131206055157124272..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: How many calendar months does a date range affect?Glen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1869924468172210809.post-10435689843742955172015-12-02T04:44:50.788+00:002015-12-02T04:44:50.788+00:00Very useful, thanks! Very useful, thanks! Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-36724364456753811612015-12-01T11:01:34.183+00:002015-12-01T11:01:34.183+00:00Thanks Jim. I think that should always give the sa...Thanks Jim. I think that should always give the same result. It was always weird the way DATEDIF was a bit of a secret in the older versions!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-47548848198462191222015-12-01T10:37:33.459+00:002015-12-01T10:37:33.459+00:00in the best traditions of multiple cat-skinning me...in the best traditions of multiple cat-skinning methods, I offer the following:<br /><br /> =DATEDIF(EOMONTH(A1,-1)+1,EOMONTH(A2,0)+1,"M")<br /><br />NB that DATEDIF() is available in 2007 and 2010, even though undocumented (not sure about other versions)<br /><br />JimAnonymousnoreply@blogger.com