MONTH and DAY formulas function differently than lesson shows

[ndporter]

In the Dates episode, in the current version of Excel for Office 365 (both Windows and Mac), the formula =MONTH(A2) in the MM_DD_YEAR sheet returns a Date formatted cell that displays as 1/11/1900 unless the column with the formula has been set to Numeric format. Likewise, =DAY(A2) shows as 1/17/1900.

I don't think this was default behavior in older versions but it was consistent for my whole 7-person workshop.

I would recommend playing around for a more reliable way to do that formula or else expanding with a note about changing the display format.