You should read my message at the link that the OP included in his message.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

Datedif was part of the ATP in E2003 butis now built in to E2007 but
remains
undocumented.

have a look here

http://www.cpearson.com/excel/datedif.aspx

Mike



"cate" wrote:

I wouldn't have a clue how to write a udf to replace this. In another
post, in this group, I was informed that this undocumented excel
function was broken in 2007 (in a service pak). Is an alternative
available?

Thank you.

http://groups.google.com/group/micro...5b5e7e4a17c106
.