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.


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] )
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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