DateDiff

Good afternoon

There is a =DateDif() function available as a standard worksheet function. Unfortunately, it doesn't appear in the Insert > Function list, or in the help (although it was documented in the Help system of XL2000, but mysteriously never before or since – no-one’s quite sure why but legal reasons are often cited). Chip Pearson’s pages offer a nice tutorial on this mysterious function.

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

HTH

DominicB