lookup for the minimum date among different dates

[khaled shaheen]

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

 

[FSt1]

hi
assuming that you sub-account dates are in B, in A enter
=min(B2:B6)
adjust ranges to suit your data.

Regards
FSt1

 

[khaled shaheen]

Hi FSt1, many thanks for your fast response however this will not help
because there will be more than one account and hence different activation
date for each account and in turn the sub-accounts that belong to each account

Below the example after having some amends on it

A B C
D
Account # Sub-Account # Account
Sub-account
activation date
activation date

2 2.11 ??
21-01-2010
2 2.12 ??
26-01-2010
2 2.13 ??
03-02-2010
3 3.111 ??
14-02-2010
3 3.112 ??
29-04-2010

Many thanks,
Khaled

 

[khaled shaheen]

Hi FSt1, many thanks for your fast response however this will not help
because there will be more than one account and hence different activation
date for each account and in turn the sub-accounts that belong to each account

Below the example after having some amends on it

A B C D
Account # Sub-Account # Account Sub-account
activation activation
date date

2 2.11 ?? 21-01-2010
2 2.12 ?? 26-01-2010
2 2.13 ?? 03-02-2010
3 3.111 ?? 14-02-2010
3 3.112 ?? 29-04-2010

Many thanks,
Khaled