return date from range of dates with if statement

J

Joe

I want to search a column that has dates in it like 1/31/2009, 2/28/2009,
3/31/2009, etc. If the date matches a date somewhere else on a sheet I want
it to do something if true and something else if false. I will tell the sheet
what date in B1 and if it finds it

I came up with:
=IFERROR(IF(INDEX(A1:A12,MATCH(B1,A1:A12,0))=B1,"TRUE","FALSE"),"0")

but thiis seems too complicated for what I am asking for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
Find product from date range 5
Populate days of the month in a column by checking on date 4
identify which years are contained within a range of dates 2
Comparing dates from VLOOKUP functions not working right 2
IF statement with 2 logicals 1
help with datedif function please 5
date range table array formula 5

Top