# DATEDIF question

• ### 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

• 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