Try this€¦

I hope there is no need to use Left function with date Values.

=IF(VALUE(TEXT(D103,"DD/MM/YYYY"))=VALUE(TEXT(E103,"DD/MM/YYYY")),1,"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


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