Lookup
This should be easy, but for the life of me I can't figure it out. I
have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Lookup
=IF(AND(WEEKDAY(A1)=5,ISNUMBER(MATCH(A1,B1:B4,0))) ,"something","something
else") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Lookup
Michael,
If you need an exact match: =IF(ISERROR(MATCH(A1,B1:B4,FALSE)),"a something","something else") If you need it within the range defined by the dates in B1:B4 =IF(AND(A1=MIN(B1:B4),A1<=MAX(B1:B4)),"something else","a something") HTH, Bernie MS Excel MVP wrote in message oups.com... This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Lookup
Try one of these:
=IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Lookup
That did it! I tried the other two, but couldn't get them to work.
This one was awesome. Thanks a lot for your help... Ron Coderre wrote: Try one of these: =IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Lookup
Thanks for the feedback....I'm glad that worked for you.
*********** Regards, Ron XL2002, WinXP " wrote: That did it! I tried the other two, but couldn't get them to work. This one was awesome. Thanks a lot for your help... Ron Coderre wrote: Try one of these: =IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
All times are GMT +1. The time now is 07:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com