Solved

Calculated columns formula - result not consistent

Posted on 2014-02-20
1
311 Views
Last Modified: 2014-02-20
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?
0
Comment
Question by:Isaac
1 Comment
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39874940
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question