| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I format a column around dates
You could SORT your data using Data Sort and using your Date column as
the key and setting it for Decending sort............or, if you only wanted to know what date was the latest and leave the data sorted as it is, then you could put this formula in any convienient cell, adjusting for your specific range..... =MAX(A1:A100) Vaya con Dios, Chuck, CABGx3 "Nikki Q" wrote: I want to format a column so that the date that is most current moves to the top of the column. Is this possible and if so how? I am logging legal due dates and they vary. Please help!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Format cell to match cells below in same column | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| How to change date from US to UK format | Excel Discussion (Misc queries) | |||
Threaded Mode
