ExcelBanter - Simple Q - Multiple IF (And) Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Simple Q - Multiple IF (And) Statement (https://www.excelbanter.com/excel-worksheet-functions/246716-simple-q-multiple-if-statement.html)

[email protected][_2_]

Simple Q - Multiple IF (And) Statement

I have to search a row of dates and identify various ranges.

I created this formula - but it errors out:

=IF(AND(B2<DATE(2011,12,31),B2(2010,12,31)),"YES" ,"NO")

Suggestions?

Glenn

Simple Q - Multiple IF (And) Statement

wrote:
I have to search a row of dates and identify various ranges.

I created this formula - but it errors out:

=IF(AND(B2<DATE(2011,12,31),B2(2010,12,31)),"YES" ,"NO")

Suggestions?

Did you miss the second "DATE"?

=IF(AND(B2<DATE(2011,12,31),B2DATE(2010,12,31))," YES","NO")

All times are GMT +1. The time now is 08:13 PM.