Enter a date into an empty, unformatted cell in your Microsoft Excel worksheet. The cell contents must include a month and four-digit year, with or without a specific day.

In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.