converting dates to T+/-

[alouder1]

I am trying to de-identify a database and need to convert dates to T+/-. For example if a person was enrolled on 7/1/2014 and the date that I am de-identifying is 7/7/2014 I need that cell to be converted to T+7. Is there any way to do this in Excel?

[hoyasaxa215]

C8 = 7/7/2014
b8 = 7/1/2014

="t+"&(c8-b8)

[alouder1]

Not even close that only works for numbers. This is what I ended up figuring out

="T+"&IFERROR(DATEDIF(B2,A2,"D"),-DATEDIF(A2,B2,"D"))

In case anyone else needs it