• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Calculated columns formula - result not consistent

Hi All,

I am using the following formula in a calculated column (Days)

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".


Any ideas?
1 Solution
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.
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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