| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort data by date excluding time
I would like to sort a database by date and transaction type. The problem is
the data sorts by time, even though the field is formatted to show date only, with the transaction type not sorting within the date because it shows up in the time order. How do I get rid of the time? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I sort data by date excluding time
If date/time column is A then you have to use an empty helper column filled
with formula =INT(A2) and sort by it. -- Regards! Stefi €žmarkd€ť ezt Ă*rta: I would like to sort a database by date and transaction type. The problem is the data sorts by time, even though the field is formatted to show date only, with the transaction type not sorting within the date because it shows up in the time order. How do I get rid of the time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date/Time Difference Excluding Weekends & Holidays | Excel Worksheet Functions | |||
| subtracting date and time formats excluding weekends | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| sort column excluding the first row | Excel Discussion (Misc queries) | |||
| How to sort time data? | Excel Discussion (Misc queries) | |||
Linear Mode
