What is the date format you have in DOJ property? YYYYMMDD?
Then:
=DATE(LEFT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),4),MID(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),5,2),RIGHT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),2))
Here's an alternative (and for some people, fun) way of mapping a date strings to excel dates using only one set of EPM formulas... Perhaps it's overkill, but i thought I'd share anyway.
=DATEVALUE(TEXT(SUM(MID(<reference to date string>,{<month start index>,<day start index>,<year start index>},{2,2,4})*10^{6,4,0}),"00-00-0000"))
and in your case:
DDMMYYYY
=TODAY()-DATEVALUE(TEXT(SUM(MID(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),{3,1,5},{2,2,4})*10^{6,4,0}),"00-00-0000"))
YYYYMMDD
=TODAY()-DATEVALUE(TEXT(SUM(MID(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),{5,7,1},{2,2,4})*10^{6,4,0}),"00-00-0000"))
For DDMMYYYY:
=DATE(RGHT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),4),MID(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),3,2),LEFT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),2))
Difference:
=TODAY()-DATE(RGHT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),4),MID(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),3,2),LEFT(EPMMemberProperty(, EPMMemberID(B14), "DOJ"),2))
Add comment