Find Earliest Date

Hello,

I have 2 dates, not in any order. I would like to create a formula to give
me the earliest date of the 2.

Example:

A B C
1 Date1 Date2 Result/Answer
2 4/20/08 1/20/08 1/20/08
3 2/28/08 5/10/08 2/28/08
4 5/7/08 2/14/08 2/14/08

I thank you in advanced for your continued support.
--
Respectfully... Elaine

Fred
Wed May 07 23:46:30 CDT 2008

=min(a2,b2)

Regards,
Fred.

"Elaine" <Elaine@discussions.microsoft.com> wrote in message
news:C997D4D2-3A11-471B-8419-E004019C849F@microsoft.com...
> Hello,
>
> I have 2 dates, not in any order. I would like to create a formula to give
> me the earliest date of the 2.
>
> Example:
>
> A B C
> 1 Date1 Date2 Result/Answer
> 2 4/20/08 1/20/08 1/20/08
> 3 2/28/08 5/10/08 2/28/08
> 4 5/7/08 2/14/08 2/14/08
>
> I thank you in advanced for your continued support.
> --
> Respectfully... Elaine

T
Wed May 07 23:48:42 CDT 2008

=MIN(A2:B2)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Elaine" <Elaine@discussions.microsoft.com> wrote in message
news:C997D4D2-3A11-471B-8419-E004019C849F@microsoft.com...
> Hello,
>
> I have 2 dates, not in any order. I would like to create a formula to give
> me the earliest date of the 2.
>
> Example:
>
> A B C
> 1 Date1 Date2 Result/Answer
> 2 4/20/08 1/20/08 1/20/08
> 3 2/28/08 5/10/08 2/28/08
> 4 5/7/08 2/14/08 2/14/08
>
> I thank you in advanced for your continued support.
> --
> Respectfully... Elaine

Elaine
Wed May 07 23:58:00 CDT 2008

I can't believe it! Here I am making it more difficult than it is.

Fred Smith & T. Valko both of you are the best.

My "humble" thank you to both of you.

Elaine
--
"T. Valko" wrote:

> =MIN(A2:B2)
>
> Copy down as needed.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Elaine" <Elaine@discussions.microsoft.com> wrote in message
> news:C997D4D2-3A11-471B-8419-E004019C849F@microsoft.com...
> > Hello,
> >
> > I have 2 dates, not in any order. I would like to create a formula to give
> > me the earliest date of the 2.
> >
> > Example:
> >
> > A B C
> > 1 Date1 Date2 Result/Answer
> > 2 4/20/08 1/20/08 1/20/08
> > 3 2/28/08 5/10/08 2/28/08
> > 4 5/7/08 2/14/08 2/14/08
> >
> > I thank you in advanced for your continued support.
> > --
> > Respectfully... Elaine
>
>
>

T
Thu May 08 00:27:02 CDT 2008

You're welcome!

--
Biff
Microsoft Excel MVP


"Elaine" <Elaine@discussions.microsoft.com> wrote in message
news:C56CC4CC-3A15-4306-AC3C-9D3554648BC7@microsoft.com...
>I can't believe it! Here I am making it more difficult than it is.
>
> Fred Smith & T. Valko both of you are the best.
>
> My "humble" thank you to both of you.
>
> Elaine
> --
> "T. Valko" wrote:
>
>> =MIN(A2:B2)
>>
>> Copy down as needed.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Elaine" <Elaine@discussions.microsoft.com> wrote in message
>> news:C997D4D2-3A11-471B-8419-E004019C849F@microsoft.com...
>> > Hello,
>> >
>> > I have 2 dates, not in any order. I would like to create a formula to
>> > give
>> > me the earliest date of the 2.
>> >
>> > Example:
>> >
>> > A B C
>> > 1 Date1 Date2 Result/Answer
>> > 2 4/20/08 1/20/08 1/20/08
>> > 3 2/28/08 5/10/08 2/28/08
>> > 4 5/7/08 2/14/08 2/14/08
>> >
>> > I thank you in advanced for your continued support.
>> > --
>> > Respectfully... Elaine
>>
>>
>>