I have a spread sheet the has 2 sheets(sheet 1 is equipment rental company bill, sheet 2 is my tracking of rented equipment usage, Sheet 2 has a vlookup formula =VLOOKUP(G4,Table1[[Chassis ID]:[Hire Date]],2,TRUE) in columns P and Q where it returns the start and end date when the piece of rented equipment matches on both sheets 1 and 2, columns H and I are the dates i tracked that we had the equipment. I have entered an if formula in column U =if(H4=P4, "yes", "no") I can blatantly see that H4 does in fact equal P4 with a date of 10/4/2016. I have formatted all the columns as dates with the same formatting scheme. Crap, I think I just found part of the answer, but now still don't understand why its only half working. Part of it was one column was stored as text originally and one a date/time so the date time would display and integer when changed to text. I entered a new column with =TEXT(Table2[[#This Row],[Start date Match]],"mm/dd/yyyy" to change them all to text. But there are still half of the column returning "no" when they should be returning "yes". I can't think of anything else.