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 lookup for the minimum date among different dates

Hi all,
I badly need your help in the below formula

Example:
Structure : Account includes Sub-accounts and each sub-account includes dials

Formula : Account activation date = Oldest Sub-account activation date

Column 1 Column 2
Account activation date Sub-account activation date
?? 21-01-2010
?? 26-01-2010
?? 03-02-2010
?? 14-02-2010
?? 29-04-2010

Account Activation date for the above account shall be 21-01-2010 (Oldest
sub-account activation date)

Thanks for your patience and usual support
Best regards,
Kshaheen


 
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
Lookup date between 2 dates Mouimet Excel Worksheet Functions 1 November 4th 09 04:59 PM
Minimum and maximum date lookup Michael Peace Excel Worksheet Functions 3 October 26th 07 06:17 PM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
Lookup a date between other dates spalmarez Excel Worksheet Functions 1 November 4th 04 09:48 PM
Lookup a date between other dates spalmarez Excel Worksheet Functions 4 November 2nd 04 09:06 AM


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

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"