excel if then statements with dates

Microsoft Excel 2003 (full product)
November 16, 2010 at 08:10:31
Specs: Windows 2003, unknown
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.

See More: excel if then statements with dates

Report •

#1
November 16, 2010 at 08:18:04
Try this:

If 11/10/09 is in cell A1
and
If 12/15/10 is in cell B1

in cell C1 enter the formula: =IF(A1>B1,A1,B1)

MIKE

http://www.skeptic.com/


Report •

#2
November 16, 2010 at 08:41:17
That did the trick. I knew it would be something simple. Thank you so much!!

Report •

#3
November 23, 2010 at 05:48:37
You can also use the following formula in Cell C1:
=MAX(A1:B1)

Report •
Related Solutions


Ask Question