Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 28

Finding the oldest & newest dates

Hi folks,

I've got a spreadsheet, where there a number of different dates & times in
column O (cells O7 through O31). All these dates are imported from different
worksheets in the same workbook, via copy/paste special.

I'd like to list the oldest date/time in cell E2 and the newest date/time in
E3. I've tried a number of different formulas with no correct results.

Can anyone provide some suggestions?

TIA, Bob

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
Finding Certain Dates	T_Sr via OfficeKB.com	New Users to Excel	2	February 11th 07 01:09 AM
Special sort for oldest and newest date	DTTODGG	Excel Discussion (Misc queries)	1	October 11th 06 05:17 PM
oldest incomplete job	floridasurfn	Excel Worksheet Functions	3	July 11th 06 05:42 PM
TEN OLDEST DATES	roy.okinawa	Excel Worksheet Functions	15	November 21st 05 05:03 AM
Finding data by dates	[email protected]	Excel Worksheet Functions	3	October 4th 05 07:54 AM

All times are GMT +1. The time now is 08:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us