Frredrik, I changed it to DateDiff as you suggested. Still the same error.

"Fredrik Wahlgren" wrote:


"PhilS" wrote in message
...
I have used the DateDif function for some time. Recently I reformatted the
drive and re-installed Office 2K. Now all the cells that have the DateDif
function entered return an #Name error. What do I need to do to correct
this
problem. Thanking all in advance.
PhilS

You have misspellt the name. It should be DateDiff

/Fredrik