How to substitute the date in a cell into a formula?

Question

Google Sheets

Hello. There is such a formula

=ПОДСТАВИТЬ(IMPORTXML("https://api.privatbank.ua/p24api/exchange_rates?date=13.03.2022";"//exchangerates/exchangerate[25]/@saleRateNB");".";",";)

You need to substitute the date in the formula from the cell. Tried to do it like this

=ПОДСТАВИТЬ(IMPORTXML("https://api.privatbank.ua/p24api/exchange_rates?date="&ТЕКСТ(A2;"DD/MM/YYYY");"";"//exchangerates/exchangerate[25]/@saleRateNB");".";",";)

But it gives an error. Perhaps someone will suggest the correct option.

Answer 1

DD/MM/YYYY
try replacing with
DD.MM.YYYY