Formula in a macro doesnt work for Spanish Excel user

Originally Posted by protonLeah

Is it necessary for you to put a formula vs the date itself?

As in post #2. After seven responses we are still waiting for the return of the OP.