LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default How do I find the earliest date?

I have a column of dates that range anywhere from 10/1/2006 to the current
day. I know I can put a filter on that column and the list will show me the
earliest date in the drop down, but I'd like to skip that step and have the
earliest date from the list of dates appear automatically in another cell.
Any suggestions???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extracting earliest date (age) from list Dave Excel Discussion (Misc queries) 1 February 5th 07 06:27 PM
finding earliest date within a range by employee Steve Excel Worksheet Functions 4 October 19th 06 11:34 PM
How do I find the earliest dates in a range of dates? JJ Excel Worksheet Functions 3 May 16th 06 09:36 AM
Find the earliest date in a range of dates? Rachel Williams Excel Worksheet Functions 2 February 10th 06 03:50 PM
Earliest Date to populate? sonquizzon Excel Worksheet Functions 2 June 16th 05 07:35 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"