ExcelBanter - How to convert Gregorian date into Hijri Date in Excel 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to convert Gregorian date into Hijri Date in Excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/219429-how-convert-gregorian-date-into-hijri-date-excel-2007-a.html)

How to convert Gregorian date into Hijri Date in Excel 2007?

In Excel Help See
Office Excel 2007 features that are not supported in earlier versions of
Excel

Ahmed wrote:

How to convert Gregorian date into Hijri Date in Excel 2007?

Ahmed wrote on Fri, 6 Feb 2009 06:54:11 -0800:

You would be better not to try asking questions solely in the subject
line. You can give much more detail in the body of a message and are
more likely to get an answer. However, just subtracting the Western date
of the Hejira would cause some problems. The definition of the new month
is based on a visual sighting at Mecca isn't it? I guess I'm not sure
whether you want not only the year but the day and month.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not