Posted to microsoft.public.excel.worksheet.functions

Gord Dibben

Posts: n/a

formula to look up and return smallest date from a range of dates

BJ

Excel stores dates as a number starting with 1 at Jan 1, 1900 so I guess that
would be the "smallest date" you could get.

With column A being dates, enter this formula in any cell in an adjacent
column.

=MIN(A:A) and Format as date.

Gord Dibben Excel MVP

On Wed, 7 Dec 2005 13:56:04 -0800, "BJ" wrote:

I need a formula that will look up the smallest date, and return it, from a
range of mixed dates.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do I create a schedule from a list of dates ?	Gavin Morris	Charts and Charting in Excel	2	October 28th 10 04:08 PM
count date occurances in range of dates...	Alex	Excel Worksheet Functions	2	July 27th 05 04:15 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Date formula: return Quarter and Fiscal Year of a date	Rob	Excel Discussion (Misc queries)	7	May 11th 05 08:48 PM

All times are GMT +1. The time now is 05:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us