Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for the minimum date among different dates
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for the minimum date among different dates
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 "FSt1" wrote: 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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup for the minimum date among different dates
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 "FSt1" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup date between 2 dates | Excel Worksheet Functions | |||
Minimum and maximum date lookup | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions |