Match Date/Time to Date list
 

I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in
D1:D10. I would like a formula to compare the date/time to the date list and
return "yes" if it is in the list and "no" if not.
Thanks

Match Date/Time to Date list
 

=IF(ISNA(MATCH(INT(A1),D1:D10,0)),"no","yes")
Bob Umlas
Excel MVP

"Sandy" wrote:

I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in
D1:D10. I would like a formula to compare the date/time to the date list and
return "yes" if it is in the list and "no" if not.
Thanks

Match Date/Time to Date list
 

Give this a try... put this formula in, say, B1 and copy down...

=IF(ISERROR(VLOOKUP(INT(A1),B1:B23,1,FALSE)),"No", "Yes")

Rick


"Sandy" wrote in message
...
I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in
D1:D10. I would like a formula to compare the date/time to the date list
and
return "yes" if it is in the list and "no" if not.
Thanks

Match Date/Time to Date list
 

Another one:

=IF(COUNTIF(D1:D10,INT(A1)),"Yes","No")

--
Biff
Microsoft Excel MVP


"Sandy" wrote in message
...
I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in
D1:D10. I would like a formula to compare the date/time to the date list
and
return "yes" if it is in the list and "no" if not.
Thanks

Match Date/Time to Date list
 

Thanks to all!