deepcalc
DocsDATE

DATE

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

Creates date from year, month, day.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number (date serial)

Examples

=DATE(2026, 7, 27)
Result 46230

Syntax

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