Let's say you have Hijri dates in B2 and down. To display them as Gregorian dates in the cells themselves, apply the custom number format B1dd/mm/yyyy to B2:B50. Or to display the Gregorian format in C2:C50, enter the following formula in C2: =B2...
Re: Convert dates from between Hijri (Islamic) and gregorian Posted 10-24-2014 07:26 AM (5252 views) | In reply to zana @jaap is partially correct it will be hard to make an exact conversion based on a formula. Do you have a specific date range in your data? Then you ...
Re: Convert dates from between Hijri (Islamic) and gregorian Posted 10-24-2014 07:26 AM (5272 views) | In reply to zana @jaap is partially correct it will be hard to make an exact conversion based on a formula. Do you have a specific date range in your data? Then you ...