Extracting a substring within Excel requires the usage of the LEFT, MID, or RIGHT functions, depending on where the substring is located within a cell. Let’s say we want to extract the root ...

DATEDIF (), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.