Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove time from a date and time field? Format removes the displa.
How do I remove time from a date and time field? Format removes the display
but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
#2
|
|||
|
|||
=INT(A1)
-- HTH RP (remove nothere from the email address if mailing direct) "oaoboc" wrote in message ... How do I remove time from a date and time field? Format removes the display but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |