I am trying to have a calculated item between two dates. What I am hoping to do is, get this item to calculate the date difference between now and another date (provided by the submitter)

I tried =DATEDIF(TODAY(),[Start Date in Current Role], "D") but getting an error message.

1 Answer 1


What's the error you are getting? #Name or #Num? The DATEDIF() function does not like negative numbers. You could try:

=DATEDIF([Start Date in Current Role],TODAY(), "D") 

If the dates do not include times (i.e. not 7/1/2018 3:34 PM), the formula can be as simple as:

=TODAY() - [Start Date in Current Role] 

If they do include times, and the time portion is to be ignored then:

=INT( TODAY() ) - INT( [Start Date in Current Role] )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.