Prevent blank date in if and index formula

[jpruffle]

Hi,

I have the following formula:

Please Login or Register  to view this content.

It works great but this column retrieves dates. Sometimes the date is blank so it returns: 00/01/1900 00:00

Can I stop this and just return a blank value instead?

Thank you in advance.

[NBVC]

Try

=IF(N($A3),IF(INDEX(yom!BB:BB,$A3)=0,"",INDEX(yom!BB:BB,$A3)),"")

[jpruffle]

Thank you works great