DAY

Description

The DAY function finds the day of the month of a given date.

Usage

DAY(date)
Argument Type Required Description
date date yes The date for which to find the day

Remarks

The result will always be in the range 1 and 31.

Example

In some cases you may want to accept only dates in the first half of the month. You can add a validation rule to ensure that the day of the month is the 15th or earlier:

DAY(reporting_date) <= 15
Next item
REGEXMATCH