Used in a Date column to extract the date portion of a date/time value.
Sample Usage
DATEONLY([Due Date]5)
Syntax
DATEONLY(
-
date_time
-
date_time—Reference to the date/time cell that contains the value from which you want to extract the date.
Usage Notes
- Currently only values in Date/Time columns in dependency-enabled project sheets and System columns include a time component. For more information, see the Column Types article.
- The DATEONLY() function will convert time and display based on GMT, not the account’s Time Zone Settings. If used on a System Date column, the date produced by the function may be different from your local timezone.