DAY Formula Generator (2026) — Extract Day from Date | Free Excel & Sheets

Returns the day of a date, a number from 1 to 31.

Generated Formula
=DAY(date)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • #VALUE! error

    Causes:
    • The input is text Excel cannot recognize as a date.
    • The cell contains an error from another formula.
    Fixes:
    • Use DATEVALUE() to convert text dates to valid date serial numbers.
    • Check the source cell for formula errors.

Frequently Asked Questions

Does DAY return the day of the week or the day of the month?

DAY returns the day of the month (1-31). For the day of the week (1=Sunday to 7=Saturday), use WEEKDAY instead.

Can DAY extract the day from a text string?

If the text is a recognizable date format in Excel, yes. Otherwise, use DATEVALUE to convert the text to a date first.

What is the difference between DAY and WEEKDAY?

DAY returns the day of the month (1-31). WEEKDAY returns the day of the week (1-7, where 1 depends on your return_type).

Related Formulas

DATEDIFNOWTODAYNETWORKDAYSYEAR

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More