Try this - Years and Month: DateDiff("yyyy",[Start_Date],Date()) & " Years and " & DateDiff("m",[Start_Date],Date()) Mod 12 & " months"