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.
In the Dates episode, in the current version of Excel for Office 365 (both Windows and Mac), the formula
=MONTH(A2)in theMM_DD_YEARsheet returns aDateformatted cell that displays as1/11/1900unless the column with the formula has been set to Numeric format. Likewise,=DAY(A2)shows as1/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.