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() = Thursday 01 December 2022
2=NOW() = Thursday 01 December 2022 06:02:29
3=TRUNC(A2) = Thursday 01 December 2022
4=INT(A2) = Thursday 01 December 2022

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


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top