Converting calendar dates to Chinese lunar dates in Google Sheets

Question

I'm trying to convert calendar dates to Chinese lunar dates in google sheets. But I have difficulties. It is easy to do in excel by using formula:

    `=TEXT(A2; "[$-130000]dd.mm.yy")`

But it doesn't work in google sheets. So, how to convert calendar dates to Chinese lunar dates in google sheets?

Answer 1

try:

=TEXT((REGEXEXTRACT(IMPORTXML(
 "http://en.nongli.info/convert/index.php?c=solar&year="&YEAR(A1)&"&month="&MONTH(A1)&"&date="&DAY(A1), 
 "//td[@colspan='2']"), "(.+\d+)")&" "&YEAR(A1))*1, "dd.mm.yy")

demo spreadsheet