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

Populate days of the month in a column by checking on date 4
Comparing dates from VLOOKUP functions not working right 2
Find product from date range 5
date range table array formula 5
Extracting dates from a String 8
Countif statement using dates 15
If Date Function 4
IF ISERROR INDIRECT MATCH Formula Question??? 19

Top