Return the date from a date and time

You can remove the time component from a date and time by using the TRUNC function.
This function will return the number with any decimal places removed.
The INT function could also be used as it returns a number rounded down to the nearest integer.

	A
1	=TODAY() = Friday 29 November 2024
2	=NOW() = Friday 29 November 2024 11:44:05
3	=TRUNC(A2) = Friday 29 November 2024
4	=INT(A2) = Friday 29 November 2024

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays just the date from cell "A2".
4 - Displays just the date from cell "A2".

Built-in Functions

INT - The number rounded down to the nearest integer.
NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.
TRUNC - The number with any decimal places removed.

Related Formulas

Return the date of the Monday in the current week
Return the day from a date
Return a date in a particular format
Return the time from a date and time