![]() |
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!!! |
All times are GMT +1. The time now is 12:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com