deepcalc
DocsDAY

DAY

View as markdown/docs/functions/day.md Ask Claude about this pageOpens Claude with this page's address

Returns day of month from date.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=DAY(DATE(2026,7,27))
Result 27

Syntax

DAY(serial_number)
serial_number
number required
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year. EDATEReturns date shifted by given months.