Problem isnumber(search

[mariec_06]

In the attached workbook, in the "chrono facture", I want the "date facture" and "date payment" to be automatically generated from worksheet "janvier".

It works fine for the first invoice nr 2016011462P but not for the others for which isnumber(search) returns "false". I have no idea where is the problem since everything looks the same to me (format etc).

Can someone has a look?

[sktneer]

You may try something like...

In F2

Please Login or Register  to view this content.

and then copy across and down.

And if you are using Excel version 2007 or later, you may use the below formula...
In F2

Please Login or Register  to view this content.

and copy across and down.