| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| dates format using gregorian and hijri calendars | Excel Discussion (Misc queries) | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
Threaded Mode
