deepcalc
DocsVALIDATE.DATE

VALIDATE.DATE

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

Validates date components form valid date.

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Boolean

Examples

=VALIDATE.DATE(2024, 2, 29)
Result true

Syntax

VALIDATE.DATE(year, month, day)
year
number required
month
number required
day
number required
FROMBYTESConverts byte array to integer. GENERATEIDGenerates unique ID with prefix and random suffix. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column.