Hi
I want a VBA code to fill column B with Geogrian Date and Column D with Hijri date
Thanks in advance
<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>
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 |