Find Earliest Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elaine - 08 May 2008 05:42 GMT

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.

Signature

Respectfully... Elaine

Reply to this Message

Fred Smith - 08 May 2008 05:46 GMT

=min(a2,b2)

Regards,
Fred.

> Hello,
>
[quoted text clipped - 10 lines]
>
> I thank you in advanced for your continued support.

Reply to this Message

T. Valko - 08 May 2008 05:48 GMT

=MIN(A2:B2)

Copy down as needed.

Signature

Biff
Microsoft Excel MVP

> Hello,
>
[quoted text clipped - 10 lines]
>
> I thank you in advanced for your continued support.

Reply to this Message

Elaine - 08 May 2008 05:58 GMT

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
--

> =MIN(A2:B2)
>
[quoted text clipped - 14 lines]
> >
> > I thank you in advanced for your continued support.

Reply to this Message

T. Valko - 08 May 2008 06:27 GMT

You're welcome!

Signature

Biff
Microsoft Excel MVP

>I can't believe it! Here I am making it more difficult than it is.
>
[quoted text clipped - 24 lines]
>> >
>> > I thank you in advanced for your continued support.

Reply to this Message