Convert Saudi Arabia date to Gregorian date in excel

[murraybj]

I an trying to convert a Saudi Date 25/04/1440 to the Gregorian format 01/01/2019, I have managed to convert from 01/01/2019 to the 25/04/2019 but cannot figure out the reverse, can anyone assist?

[JeteMc]

Hello murraybj and Welcome to Excel Forum.
I am probably missing something, however it seems to me that converting January 1st to April 25th involves adding 114 days, so reversing the process would involve subtracting 114 days.
Assuming the date 25/4/2019 is in cell A2 use: =DATE(YEAR(A2),MONTH(A2),DAY(A2)-114)
As to converting the year, perhaps the information in the linked thread will be helpful.
https://www.excelforum.com/excel-gen...-1-1900-a.html
Let us know if you have any questions.

[shg]

You can format Gregorian dates to appear as Hijri dates:

	A	B
1	1 Jan 2019
2	24/04/1440	A2: =A1
3		Format of A2: B2dd/mm/yyyy

See https://answers.microsoft.com/en-us/...7-312c61c417e1 for how to enter Hijri dates; it appears to require a registry key.