=datedif() in the worksheet
datediff in VBA

My bet it isn't your function (=datedif()), it's something else in the formula.

You may want to post the whole formula if you can't isolate the problem.

PhilS wrote:

I have used the =DateDif function in the past. I recently had to format my
drive and reinstalled Office 2k. When I returned my application, all the
cells using the =DateDif function returned a #Name error. Hope someone can
assist. Thank you in advance.
Phil

--

Dave Peterson