Converting hijri date to gregorian date
 

good evening,
How can i make a formula to automatically convert the hijri date to
gregorian date:
A B
21/11/1430 11-nov-09
i want to type the hijri date in column A, then automatically convert this
date into Gregorian date or calendar. Someone helfp me plss!!!!!!!!!!!!

Thank you very much in advance,

hijri to gregorian
 

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

A2: the date you are looking for