Try,
=IF(LEFT(Text(D103,"dd/mm/yyyy"),10)=LEFT(TEXT(E103,"dd/mm/yyyy"),10),"1","")

You need to make sure you are using LEFT on a string, then it should work
perfectly.
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Fats" wrote:

Hello,

Need some assistance on the following:

=IF(LEFT(D103,10)=LEFT(E103,10),"1","")

D103 is a link to a MS Project file cell containing a date and time - eg.
"13/09/2010 11:00:00 AM". E103 is a date - eg. "13/09/2010".

The above formula should produce "1" when the first 10 characters match. How
ever it does not. Can any one see my error or offer a better formula to get
the result I am after?

Thanks for your help in advance.

Ant.
--
Cheers
Ant.