| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I format a column around dates
You don't give a lot of details of what you are doing. There is no "Format" that will do what you ask. A simple answer is to use the Data SORT Descending feature, using your date column as the "Sort By:" column. You could also use the Auto-Filter feature. As you enter new rows at the bottom of the range, select the arrow at the top of your Date column, and use that to Sort Descending... Do these work for you? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=541628 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell to match cells below in same column | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | 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
