<div>
<div class="content wysiwyg-content">
Hi All, <br />
<br />
I am using the following formula in a calculated column (Days)<br />
=DATEDIF(AssignToAnalyst,R<wbr />esponseDat<wbr />e,&quot;D&quot;)<br />
<br />
For some of the items it works and for some it does not.<br />
I don't understand why.<br />
<br />
Below is my list:<br />
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. &nbsp;<br />
<br />
I'm just trying to find the number of days between &quot;AssignToAnalyst&quot; and &quot;ResponseDate&quot;.<br />
<br />
<a href="http://isaac.issharepoint.com/Lists/Log/AllItems.aspx" rel="ugc">http://isaac.issharepoint.com/Lists/Log/AllItems.aspx</a><br />
<br />
Any ideas?
</div>
</div>


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?

Calculated columns formula - result not consistent

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.