| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gregorian Date from Hijri
the following function converts Gregorian Date to Hijri
But when I do the opposite it done work, I mean convert a Hijri date to Gregorian. Any Help?!! Function DHijri(dtGegDate As Date) As String ' returns a date in Hijri format for a given western date VBA.Calendar = vbCalHijri DHijri = dtGegDate VBA.Calendar = vbCalGreg End Function Thanks Abdul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting hijri date to gregorian date | Excel Discussion (Misc queries) | |||
| Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| dates format using gregorian and hijri calendars | Excel Discussion (Misc queries) | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
![Abdul[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
