Compare day and time cell with date cell

[LEFT]Hello,

I have one column with date and time (A2 cell: 2015.01.21 03:19:23) and i want to to a formula if A2 date is later than 2015.01.20 then "buy",if before "sell", if the same date "no". How can i do that when on one cell i have only date and on the other i have day and time?

I'm not sure if that is a proper date/time in A2, as a full-stop is not a usual delimiter for a date. Please attach a sample workbook so it can be checked.

Hope this helps.

Pete

Please find attached an example. I want to test open date is the same later or before with the one on k2. The same with the Close date

Thanks

You can use this to test for the open date (column B):

=IF($K$1=LEFT(B2,FIND(" ",B2)-1),"no",IF(--SUBSTITUTE($K$1,".","/")<--SUBSTITUTE(LEFT(B2,FIND(" ",B2)-1),".","/"),"buy","sell"))

To test for the close date (column E) change the B2 references to E2, then copy both formulae down.

Hope this helps.

Pete

Thanks a lot guys