Calculated columns formula - result not consistent

Hi All,

I am using the following formula in a calculated column (Days)
=DATEDIF(AssignToAnalyst,ResponseDate,"D")

For some of the items it works and for some it does not.
I don't understand why.

Below is my list:
I know why I know why it shows #NUM! in 2 of the columns but not sure why I get 334 in the last column.  

I'm just trying to find the number of days between "AssignToAnalyst" and "ResponseDate".

http://isaac.issharepoint.com/Lists/Log/AllItems.aspx

Any ideas?
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
if you simply subtract the AssingToAnalyst date from the RespondDate, you get the same number, 334.   You can actually use the simple subtraction instead of the DATEDIF to get same results.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.