Used in a Date column to extract the date portion of a date/time value.
Sample Usage
DATEONLY([Due Date]5)
  • 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.