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.


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays just the date from cell "A2".
Cell "A4" displays just the date from cell "A2".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
3=TRUNC(A2) = Sunday 01 May 2022
4=INT(A2) = Sunday 01 May 2022

Built-in Functions

INT - The number rounded down to the nearest integer.
NOW - The serial number of the current system date and time.
TODAY - The 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