Microsoft Excel 2003 (full product)

In an excel spreadsheet, I have two colums, each with a date in it. I want the third column to yield the greater of these two dates. For example, column one has 11/10/09, column two has 12/15/10, I want column three to show 12/15/10 as the greater of these two dates. Thanks.

Try this: If 11/10/09 is in cell A1

and

If 12/15/10 is in cell B1in cell C1 enter the formula: =IF(A1>B1,A1,B1)

MIKE

That did the trick. I knew it would be something simple. Thank you so much!!

You can also use the following formula in Cell C1:

=MAX(A1:B1)

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History