How to enter & convert Arabic/Hijri to Gregorian Date to In Excel

[@mehdihammadi6145]

Thank you for sharing. I know about the first tip and every time I show it to my attendees they try to figure out what is there birthday in hijri date. However it not concord 100% any time. But the second tip is awesome and totally new for me. So thank you again for sharing

[@ExcelExciting]

@Mehdi :) Glad You like it.. thank you..stay connected for more amazing tips

[@hashamfakir4370]

This is really good, we we're looking for a solution for ages... finally we found it. Thank you! Master

[@ExcelExciting]

Thank you sir

[@OzduSoleilDATA]

OH LORD! The Registry???? Good tip! Something I've never seen before.

[@ExcelExciting]

Few months back I got data with Arabic dates that drive me crazy.. my team need to go to internet for date conversion or use Arabic excel version to feed the Arabic data in excel & that was consuming lot of time.. I thought it should have end & after some R&D I got this 🥰 Now things moving smoothly..

[@entertainmentgalaxy971]

wow. very informative. thanks for sharing

[@ExcelExciting]

Glad You like it.. thank you..stay connected for more amazing tips

[@gambo2246]

Thanks .. that was a good tip This registry entry is actually there in all Arabic versions of Excel👍.. so by adding that registry entry into other non-arabic Excel versions .. they become "hijri enabled" btw ... how do i get the month name from the arabic date ... i tried =month() but it returns the Gregorian month number / name ??

[@aslammohammed2746]

Hi Faraz Thank you for sharing, after converting date to Arabic i need to hide format and upload to google calendar thus its shows English date i need there to show hijra date how? i have a template in .csv format its works very well what subject we give it will display there on calendar belong to date

[@mohammedabdulghaffar5281]

Thank you Please how to add A before the hijri data for all cells on the data with 100 cells

[@ExcelExciting]

Good question.. you can concatenate the text, make sure your date locale settings matching with the Arabic data “.a21-04-1440” & replace the "." With blank that will update the information.. "I will soon share a solution video on the same.."

[@safashaikh4089]

Excellent video 😊

[@ExcelExciting]

thank you

[@shakiraasfoor7599]

great,, my problem is when i pivot my data i couldnot use arabic months insted of jan , feb

[@ExcelExciting]

noted you query.. shall soon make solution video on the same..

[@ahazem]

How to apply hijri date corrections? + 1d or -1d to what excel auto calculate with B2dd/mm/yyyy?

[@galymzhankyrykbaev2976]

add the additional colum and write =B2±1 for example

[@abdullahquhtani4247]

This method is good but there is a problem with pivot table where Arabic Hijri months don’t be displayed.

[@asifpatel8205]

Good

[@nabeelhasan2399]

12 Rabi ul awwal Georgian date

[@hassanhak]

Thankyou

[@ExcelExciting]

Welcome.. what was your use case for Arabic date ?

[@hassanhak]

@@ExcelExciting well i have got some expiry dates which i needed to see in GC form. It was a huge data, got it done in few minutes, thanks to this video tutorial.