I need to return cell that are blank or within a date range
Col A Col B Col C
1 Red 11/7/8 Red
2 Green Green
3 Black 30/6/8

So if Col B is between 1/7/8 and 31/07/08 or blank return Col A in column C
Answer C1 = Red, C2 = Green, C3 = Blank

Many thanks

=IF(OR(B1="",AND(B1=--"2008-07-01",B1<--"2008-08-01")),A1,"")

--
__________________________________
HTH

Bob

"Porlie" wrote in message
...
I need to return cell that are blank or within a date range
Col A Col B Col C
1 Red 11/7/8 Red
2 Green Green
3 Black 30/6/8

So if Col B is between 1/7/8 and 31/07/08 or blank return Col A in column
C
Answer C1 = Red, C2 = Green, C3 = Blank

Many thanks

=IF(OR(TEXT(B1,"mmyy")="0708",B1=""),A1,"")

"Porlie" wrote:

I need to return cell that are blank or within a date range
Col A Col B Col C
1 Red 11/7/8 Red
2 Green Green
3 Black 30/6/8

So if Col B is between 1/7/8 and 31/07/08 or blank return Col A in column C
Answer C1 = Red, C2 = Green, C3 = Blank

Many thanks

Another one:

Assuming 08 stands for year 2008.

=IF(OR(B1="",B1=MEDIAN(B1,"2008/7/1","2008/7/31")),A1,"")

Copy down as needed.

Or, use cells to hold the date range:

D1 = 7/1/2008
E1 = 7/31/2008

=IF(OR(B1="",B1=MEDIAN(B1,D$1:E$1)),A1,"")


--
Biff
Microsoft Excel MVP


"Porlie" wrote in message
...
I need to return cell that are blank or within a date range
Col A Col B Col C
1 Red 11/7/8 Red
2 Green Green
3 Black 30/6/8

So if Col B is between 1/7/8 and 31/07/08 or blank return Col A in column
C
Answer C1 = Red, C2 = Green, C3 = Blank

Many thanks