View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Haddox Haddox is offline
external usenet poster
 
Posts: 5
Default DATEDIF "md" 2007 issue?

Also, Rick - strange (or maybe not), but swap out any month/year and you get
the same result. For example:

=DATEDIF(DATE(1956,4,27),DATE(2012,1,5),"md")

=DATEDIF(DATE(2011,12,27),DATE(2012,1,5),"md")

Perhaps related to that end date? Any ideas or source of further info I can
contact would be appreciated.



"Rick Rothstein" wrote:

That's odd... I get 9 in XL2003 and I get 122 in XL2007.

My XL2007 is at SP2... what service pack level are you at?

--
Rick (MVP - Excel)