Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

The DAY function returns the day of the month. For example:

=DAY(A1) will return 15 if A1 contains the date 1/15/2020.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.