Formula including dates

On an Excel spreadsheet, I have numerous columns with dates. How do I write
the formula so that if the dates in Column I OR Column L are before today's
date, it will default to "x" in column C? If the dates in BOTH columns are
after today's date, I want it to default to "a" in column C. Thanks in
advance.

Have a look in HELP index for using IF in a formula

--
Don Guillett
SalesAid Software
donaldb@281.com
"R L Sandel" <R L Sandel@discussions.microsoft.com> wrote in message
news:14D10A1F-1FEC-43D0-87AF-8AE5D3331F0B@microsoft.com...
> On an Excel spreadsheet, I have numerous columns with dates. How do I
write
> the formula so that if the dates in Column I OR Column L are before
today's
> date, it will default to "x" in column C? If the dates in BOTH columns
are
> after today's date, I want it to default to "a" in column C. Thanks in
> advance.

What if the dates are today's date?


If "a":

C1: =IF(AND(I1>=TODAY(),L1>=TODAY()),"a","x")

If "x":

change >= to >

In article <14D10A1F-1FEC-43D0-87AF-8AE5D3331F0B@microsoft.com>,
"R L Sandel" <R L Sandel@discussions.microsoft.com> wrote:

> On an Excel spreadsheet, I have numerous columns with dates. How do I write
> the formula so that if the dates in Column I OR Column L are before today's
> date, it will default to "x" in column C? If the dates in BOTH columns are
> after today's date, I want it to default to "a" in column C. Thanks in
> advance.