Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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?
0
Isaac
Asked:
Isaac
1 Solution
 
NBVCCommented:
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now