The below formula works only if the D103 is in text format....or else you
will have to use TEXT() function as mentioned in the other posts....

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

Try

=IF(LEFT(D13,10)=TEXT(E13,"dd/mm/yyyy"),1,"")

--
Jacob (MVP - Excel)


"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.