View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Taha Lahlou Taha Lahlou is offline
external usenet poster
 
Posts: 1
Default 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