One way to correct this behavior is to change your default date system. On the Mac version of Excel, you can do this within the calculation pane of Excel's preferences.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage ...

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.

If numbers keep changing to dates automatically in Excel or if Excel changes dates to random numbers then this post will help you fix the issue.