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?

Mccomas

see if it helps: docs.google.com/spreadsheets/d/… – Morpheus

looks like its a paid job: upwork.com/freelance-jobs/apply/… – Morpheus

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

Morpheus