#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
torpido
 
Posts: n/a
Default converting Dates


hi guys
been some time since last time i showed up
anyway...
as u guys know there r serveral calenders type, what i want is function
that converts a type to another, like convert a crist date to Qamari or
Shamsi(islamic) dates.
for example today:
10/10/1384 shamsi to 31/12/2005


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=497155

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default converting Dates

On Sat, 31 Dec 2005 09:00:57 -0600, torpido
wrote:


hi guys
been some time since last time i showed up
anyway...
as u guys know there r serveral calenders type, what i want is function
that converts a type to another, like convert a crist date to Qamari or
Shamsi(islamic) dates.
for example today:
10/10/1384 shamsi to 31/12/2005


I don't believe you can devise such a function that will give guaranteed
accurate results for religious purposes.

The Islamic calendar is a strictly lunar calendar, and the time of the New Moon
can be accurately predicted.

However, my understanding is that each Islamic 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.


--ron
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default converting Dates

On Saturday, December 31, 2005 at 9:13:24 PM UTC+3:30, Ron Rosenfeld wrote:
On Sat, 31 Dec 2005 09:00:57 -0600, torpido
wrote:


hi guys
been some time since last time i showed up
anyway...
as u guys know there r serveral calenders type, what i want is function
that converts a type to another, like convert a crist date to Qamari or
Shamsi(islamic) dates.
for example today:
10/10/1384 shamsi to 31/12/2005


I don't believe you can devise such a function that will give guaranteed
accurate results for religious purposes.

The Islamic calendar is a strictly lunar calendar, and the time of the New Moon
can be accurately predicted.

However, my understanding is that each Islamic 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.


--ron


hi, after long time
I should remind that, islamic hijri shamsi calendar is "solar" calendar
and that is another, islamic hijri ghamari calendar is "lunar".
shams (ar) == sun
ghamar (ar) == moon
( this should be exciting that , month is change of maangh in iran_kurdish lang,
[ maah in modern persian = moon(en)]
and again "mania" is change of word "mang" in all iranian languages.)

good luck
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
imported text data converting to dates ajd Excel Discussion (Misc queries) 2 December 21st 05 06:48 PM
Excel should have a formula for Converting Julian Dates Yakimeshi Excel Worksheet Functions 0 May 17th 05 06:23 PM
Excel should have a formula for Converting Julian Dates Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:15 PM
Converting Text months to sortable Numbers or Dates Greg Excel Discussion (Misc queries) 6 May 1st 05 03:32 AM
converting dates into numbers help me Excel Discussion (Misc queries) 3 December 17th 04 03:11 AM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"