none
datediff error across columns in a list

    Question

  • Hello

    I have 3 total columns.  "AAA" is a date selected by a user on input of the entry, "BBB" is a date column set to "today", "CCC" is the column I have done for the date differential between AAA and BBB.  CCC is a calculated column.  I want it to display negative numbers also. 

    The formula I used is =DATEDIF([AAA],[BBB],"D")

    This returns a #Num? error and sometimes when playing with the formula a #Name? error in the column.

    Any help would be great.

    Monday, April 10, 2017 7:52 PM

Answers

  • Please check below articles for more details:

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/ac9a1b8c-cd98-4e07-9fe7-8657cb8c3aae/calculated-columns-does-not-show-negative-value?forum=sharepointgenerallegacy

    https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

    https://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/


    Thanks, Amit Kumar, LinkedIn Profile ** My Blog
    Please click "Mark As Answer" if this post solves your problem or "Vote As Helpful" if it was useful

    • Marked as answer by wav3rider Monday, April 17, 2017 4:16 PM
    Tuesday, April 11, 2017 6:15 AM

All replies

  • Here you go

    http://sharepoint.stackexchange.com/questions/175462/calculated-field-with-formula-datedif


    Please remember to click Mark as Answer on the answer if it helps you

    Monday, April 10, 2017 8:06 PM
  • Please check below articles for more details:

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/ac9a1b8c-cd98-4e07-9fe7-8657cb8c3aae/calculated-columns-does-not-show-negative-value?forum=sharepointgenerallegacy

    https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

    https://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/


    Thanks, Amit Kumar, LinkedIn Profile ** My Blog
    Please click "Mark As Answer" if this post solves your problem or "Vote As Helpful" if it was useful

    • Marked as answer by wav3rider Monday, April 17, 2017 4:16 PM
    Tuesday, April 11, 2017 6:15 AM
  • Thank you everyone! Amit I used the TechNet link to achieve my result.

    Tuesday, April 11, 2017 12:02 PM