Evaluate formula

[efernandes67]

Hi,

I have a table named 'table1' with 2 columns, 'Name' and 'sdate'

Please Login or Register  to view this content.

What do I need to change in the 2nd Evaluate formula to make it work?

Regards,
Elio Fernandes

[Alf]

Have you tried to dim sDt as String?

Alf

[watersev]

hi Elio, A16:E16 have word "test" in on of the cells

Please Login or Register  to view this content.

[efernandes67]

I tried with String, Date and Variant!

Elio Fernandes

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[efernandes67]

Hi,

I just found a way to work with this date issue.

Please Login or Register  to view this content.

Thanks for your help.
Elio Fernandes