Hi,

Often use this forum for help with my formulas but this is my first post as a member.

Version: Excel 2007
OS: Windows XP

So here's my query...
Cell A1 containts: "01/01/1990 to 01/01/2005"

I want to read the first date in the cell and return "Yes" if the date is before 01/01/2004

Current formula: "=IF(LEFT(A1,10)="<DATE(01,01,2004)","Yes","No")"

The formula keeps returning "No" regardless of the dates in the cell.

Hope this is clear and I havn't forgotten any info!

Thanks,
Oscar