locked
DATEDIF question RRS feed

  • Question

  • I need to use DATEDIF function, currently i am using this for calculating the date difference between "create" and "resolve date" and if suppose no "resolve date" it gave me answer as "Open Ticket" ....

    =IF(ISERROR(DATEDIF(Created,[Resolve Date],"d")),"Open Ticket",DATEDIF(Created,[Resolve Date],"d"))

    My question is that if no resolve date, its calculate the "create date - today date = Open ticket (no of days).

    example: Created date  1/10/2015 , today's date 1/21/2015 , NO RESOLVE DATE

    it should come with = Open Ticket(11)

    Wednesday, January 21, 2015 6:42 AM

Answers

  • Hi

    check this formula

    IF(ISBLANK([resolve date]),DATEDIF(Today, [Created],"d"),"Resolve date column is not empty")


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.


    Wednesday, January 21, 2015 7:01 AM

All replies

  • Hi

    check this formula

    IF(ISBLANK([resolve date]),DATEDIF(Today, [Created],"d"),"Resolve date column is not empty")


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.


    Wednesday, January 21, 2015 7:01 AM
  • Hi

    also check this similar issue

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/eb3134ed-87fb-42b5-89d8-df7dd346d629/calculated-column-date-return-null-value-when-source-date-column-is-blank?forum=sharepointgeneralprevious


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Wednesday, January 21, 2015 7:02 AM