I imported data from MS Project 2013 into an Excel worksheet (copy/paste). The data included some date values. In a second spreadsheet I used the HLOOKUP() function to bring in a set of column information in order to do standard reporting. When I tried to do some conditional formatting based on date column comparison I found it did not work. I realized the dates were text by using the ISTEXT() function. I tried using the DateValue() function in order to convert and do the comparisons, but keep getting a #Value! error. The columns are general format. Any suggestions?