lookup for the minimum date among different dates

K

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
 
F

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
 
K

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top