search formula

Hi,

I still think you'rec approaching this the wrong way.

First get the right date using the Date Validation parameter. So with the Date validated in say A1
in another cell say B1 have the following function

Formula:

=TEXT(A1,"yyyy-mm-dd")

Then when you export the file use the B1 value