DATE Conversion - Gregorian to Hijr in Google Sheet

Question

Im trying Gregorian date to Hijr dates

i have this in excel but this format is not working in google sheeet please anyone know how can i format Gregorian to Hijr in google sheet

[$-,117]B2dd-mm-yyyy;@

Answer 1

here is my solution

=VLOOKUP(A2;IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bRjd8tBXujn4C1pMi5onqLS8CUQ_Wp9IkW2OkgFQ2nU";"HijriDates!$A$1:$D");3;0)

A2: the date you are looking for