Calculating age of death
I also get 122
Gord
On Fri, 4 Mar 2011 13:21:30 -0500, "Rick Rothstein"
wrote:
I am running SP2...............not broke<g
I get 4 as an answer also, however, those dates were not the ones I posted
to show the problem. Try this formula in one of your XL2007 cells...
=DATEDIF(DATE(2009,6,27),DATE(2012,1,5),"md")
In my copy of XL2007 SP2, I get an answer of 122... it should be 9. What
answer do you get?
Rick Rothstein (MVP - Excel)
|