Use this function in a Date column to extract the date portion of a date/time value.
- date_time—Reference to the date/time cell that contains the value from which you want to extract the date.
- 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 and display time based on GMT, not the account’s time zone settings. If you use DATEONLY on a System Date column, the date produced by the function may be different from your local time zone.