VBA code to change Hijri date to gegorian and gegorian date to Hijri ( Help please)

[bmarroush]

Hi

I want a VBA code to fill column B with Geogrian Date and Column D with Hijri date

Thanks in advance

​

Excel 2013
Serial	A	B	C	D
1	14/01/1439		01-Jan-16
2	14/01/1440		02-Jan-16
3	14/01/1441		03-Jan-16
4	14/01/1442		04-Jan-16
5	14/01/1443		05-Jan-16
6	14/01/1444		06-Jan-16
7	14/01/1445		07-Jan-16
8	14/01/1446		08-Jan-16
Sheet1

<colgroup><col width="120" style="width: 90pt; mso-width-source: userset; mso-width-alt: 4388;"> <col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" span="3"> <tbody> </tbody>

 

[Andrew Poulsom]

Why do the Hijri dates start in 1439 and increment by one year while the Gregorian dates start in 2016 and increment by one day?

 

[bmarroush]

Hi Andrew

Thanks for the reply

Actually i just put it as an example to have a continous change but i will change it once i insert the VBA code

Really appreciated if you can help me over this

Thanks in advance

 

[Andrew Poulsom]

To see a Gregorian date as a Hijri date format the cell as B2dd/mm/yyyy.

 

[bmarroush]

Thansk Andrew

Sry but i didnt get it you All what i need is a VBA code which let me able to change all Hijri dates i have in my sheet to gregorian

Thansk

 

[Andrew Poulsom]

I don't know why you need VBA code. Maybe this will help you:

http://www.mrexcel.com/forum/excel-questions/534307-hijra-date-into-gregorian.html