Try DATEDIF.

You could use the following if you want to see the number of years and
the number of days that are not a complete year:
=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"yd")&" days"

Replace both A2 references with IF(ISBLANK(A2),TODAY(),A2) for the
blank issue.

On Dec 22, 7:36*am, Kim wrote:
Can anyone help please? *I want to calculate employee length of service from
start date (A1) where there is a leave date (B1) or (B1) is blank and should
use TODAY as the reference date.