The Shortcut AI agent for Excel could be the next boon — or threat — to white collar workers who spend all day in spreadsheets.

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.

QUICK ANSWER To calculate someone's age in Excel, enter the formula =DATEDIF (A2,TODAY ()," y"), where cell A2 contains the date they were born and "Today" is today's date. Press Enter, and Excel ...

The Shortcut AI agent for Excel could be the next boon — or threat — to white collar workers who spend all day in spreadsheets.