I like to convert dates in excel to Iranian and islamic - lunar calendar?

On Sun, 27 Jan 2008 20:28:01 -0800, m nassiri <m
(E-Mail Removed)> wrote:

>I like to convert dates in excel to Iranian and islamic - lunar calendar?

I don't know about the Iranian calendar, but I don't believe it is possible to
compute a true (religious) Islamic calendar.

My understanding (from http://www.tondering.dk/claus/cal/node6.html ) is that
each month starts when the lunar crescent is first seen (by an actual human
being) after a new moon.

Although new moons may be calculated quite precisely, the actual visibility of
the crescent is much more difficult to predict. It depends on factors such as
weather, the optical properties of the atmosphere, and the location of the
observer. It is therefore very difficult to give accurate information in
advance about when a new month will start.

Furthermore, some Muslims depend on a local sighting of the moon, whereas
others depend on a sighting by authorities somewhere in the Muslim world. Both
are valid Islamic practices, but they may lead to different starting days for
the months.


--ron

By totally agreeing with Ron, the following function will convert date
to Hijri.


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

Abdul


Ron Rosenfeld wrote:
> On Sun, 27 Jan 2008 20:28:01 -0800, m nassiri <m
> (E-Mail Removed)> wrote:
>
> >I like to convert dates in excel to Iranian and islamic - lunar calendar?
>
> I don't know about the Iranian calendar, but I don't believe it is possible to
> compute a true (religious) Islamic calendar.
>
> My understanding (from http://www.tondering.dk/claus/cal/node6.html ) is that
> each month starts when the lunar crescent is first seen (by an actual human
> being) after a new moon.
>
> Although new moons may be calculated quite precisely, the actual visibility of
> the crescent is much more difficult to predict. It depends on factors such as
> weather, the optical properties of the atmosphere, and the location of the
> observer. It is therefore very difficult to give accurate information in
> advance about when a new month will start.
>
> Furthermore, some Muslims depend on a local sighting of the moon, whereas
> others depend on a sighting by authorities somewhere in the Muslim world. Both
> are valid Islamic practices, but they may lead to different starting days for
> the months.
>
>
> --ron

On Sun, 27 Jan 2008 22:37:58 -0800 (PST), Abdul <(E-Mail Removed)>
wrote:

>By totally agreeing with Ron, the following function will convert date
>to Hijri.
>
>
>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
>
>Abdul

The only caution is that this calendar may differ from the "true" religious
Islamic calendar by a day or so.
--ron