DAY Function in Google Sheets

Syntax

DAY(date)

Description

Returns the day of the month that a specific date falls on.

Tips & Best Practices

Returns 1-31. Use with MONTH and YEAR to decompose dates.

Example

=DAY(...)

The DAY function belongs to the Date category of Google Sheets functions.

Related Functions

• TODAY — Returns the current date....
• NOW — Returns the current date and time....
• DATE — Converts a year, month, and day into a date....
• DATEVALUE — Converts a provided date string in a known format to a date value....
• MONTH — Returns the month of the year a specific date falls in....
• YEAR — Returns the year specified by a given date....

Need Help with DAY?

If you're struggling with DAY or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →