Lunar conversion
I'm telling you, this is unreliable, it can't be calculated at all, and the transformation involved is not a simple formula. On the contrary, its transformation is quite complicated.
If you are interested in writing programs, I can provide a library of conversion functions. You can realize the conversion between the lunar calendar and the Gregorian calendar by calling a function.
At present, I have realized the transformation perfectly, and I can provide it if necessary.
What is the formula for converting the lunar calendar into the Gregorian calendar? Because the Gregorian calendar (the Gregorian calendar is used now, and the Confucian calendar was used before) and the China lunar calendar are not calculated strictly according to a formula, there is no direct formula for the two calendars.
It is impossible to use a simple formula instead of using a lot of data like a perpetual calendar (although it can be simplified) to achieve the purpose of conversion between public and lunar calendar. All the software that we can see to convert Gregorian calendar into lunar calendar contains calendar data of different years.
Among these data, the most important is the number of days in each month of the lunar calendar. Because the lunar calendar is a lunar calendar, the part of the lunar calendar (according to the phase of the moon) determines a certain day in a month, and the part of the solar calendar (according to the height of the sun) is a solar term. Solar terms basically correspond directly to the Gregorian calendar, which is easy to calculate; However, the relationship between the moon phase period and the earth's revolution is relatively complicated, and generally requires astronomical observation data to give the time, so there is no simple formula for whether a lunar month is a big moon or a small moon.
As for the leap between the Gregorian calendar and the lunar calendar, there is a certain calculation method, which is not difficult.
If it is only astronomical data, it can still be counted-because the astronomical period is very stable, we only need to calculate it strictly according to the astronomical period. But there is another troublesome point, that is, the solar calendar and the lunar calendar are not strictly in accordance with the actual astronomical cycle, and there are many human factors. The most famous is that the Roman emperor revised the length of February and August for many times. Due to inaccurate calculation, the 10th was artificially deleted from julian calendar. In China, the calendar published by * * * is inconsistent with the astronomical phenomena because the ancient astronomical observations are inaccurate (we can't demand the accuracy of ancient observations). Therefore, these two calendars are related to a period of society, so there is no certain law to follow.
How to convert China's solar calendar, lunar calendar and solar calendar in dates? Baidu is too complicated to study by itself.
The comparison table for converting the lunar calendar into the Gregorian calendar is Gregorian calendar1Sunday, April 29th, 945.
How does excel convert solar calendar formula from lunar calendar? For example, today is September 2, 20 10, and the following formula can be used to get July 24 of the lunar calendar:
Although the result is a bit unsatisfactory in the leap month, as shown in the following figure, February 9 of the 20th10 of the lunar calendar should be1February 26, but there was a leap month that year, so there was an innocent month. But it's much faster than coding, and leap months don't happen every day.
If the formula is changed to =MID (methyl, ethyl, propyl, butyl, hexyl, octyl, non-undecyl, mod (text (a2, [$- 130000] e)-4,10)+1)&; MID (Zi Chou Mao Yinchen asked for a letter at noon), mod (text (a2, [$- 130000] e)-4, 12)+ 1,1)&; year & Text(a2,[$- 130000][DBM num 1]m month)&; Text (A2, if (-text (A2, [$- 130000] d) = 10, the tenth day, if (-text (A2, [$-130000] d) >/kloc-0.
What are the rules of conversion between lunar calendar and solar calendar? No. The solar calendar takes the time for the earth to orbit the sun once (that is, 365 days, 5 hours, 48 minutes and 46 seconds, that is, 365.2422 days) as a year. In order to facilitate the calendar, it is set to 365 days (called an average year), leaving 0.2 days and 0.2422 days, which is 0.9688 days every four years, nearly one day. So every four years, one day is added to the year divisible by 4, and this year is 366 days (called leap year, that is, February 29 days), which is 3. 12 days less every 400 years, that is, three leap years less. So every hundred years is a leap year that can be divisible by both 4 and 400. That is what we usually say: leap in four years, not in a hundred years, and then jump in four hundred years.
In the lunar calendar, the time for the moon to orbit the earth once (that is, 29 days on average, 12 hours and 44 minutes) is one month, and 12 months is one year, that is, 354 days. There is a leap month year every three years, and the leap month year is 383 days or 384 days. /kloc-7 leap months in 0/9 years. Generally, the solar calendar 19 and the lunar calendar (19 years) can meet together or only one day apart.
How to convert lunar calendar into national calendar and Gregorian calendar
Derivation of conversion formula of 1.
Gregorian calendar is 365.242 199074075 days per year (simplified as 365.2422 days), while Hijri calendar is 354.367074375 days per year (simplified as 354.36707 days), so Hijri calendar is only equivalent to 354.36707/365.2422 = 0.9723.2008080806 New Year's Day in the first year of Muharram was set on July 622 16. Due to the calculation error of the calendar at that time, according to the modern Gregorian calendar, the current July 16 should be changed to July 19, and the period from New Year's Day to July 19 of that year has reached 200 days. Phase 200/365.2422 = Because it didn't reach 0.970224 calendar year until the second year of Hijrayan, the formula for converting from Hijrayan to Gregorian is:
(Muharram 1 year 1 1)×0.924+622.76. 56637.86666666667
= Gregorian calendar date ............................................. (1)
Or hijri calendar year × 0.970224+62 1.5774.
= Find the calendar year, month, year, month, year, month, year, month, year, month, year, month, year, month, year, year, month, year, month, year, year, year, month, year, month, year, month, year, year, month, year, month.
Among them, 62 1.5774 comes from 622.5476-0.9274.
If a historical fact is not found on the first day of New Year's Day, the total number of days that have passed this year can be converted into Gregorian years and added to the total number of Gregorian years.
However, the total number of days in the above-mentioned Gregorian calendar year is actually the measured number in the tropic year, because the number of days in the current Gregorian calendar year is actually 365.2425 days, which can only be basically consistent with the number of days in the tropic year, and there will be a difference of one day after more than 4,000 years.
In fact, the Gregorian calendar in the ten years of Wanli of Ming Dynasty, September 18, 990, 16,1June 4, 582 (including 4 days) is called julian calendar, and julian calendar has 365.25 days every year, which is far more different from the Gregorian calendar, that is, the modern Gregorian calendar is about/kloc. Therefore, we still can't use two formulas (1) and (2) for the conversion between the official calendar and the official calendar in julian calendar period, but we need to modify the above two formulas slightly according to the actual number of days in julian calendar. The results are as follows:
(IJL) × 0.9702+622.5393
= Represents Gregorian year, month, year, month, year, month, year, month, year and year (3)
Calendar year × 0.9702+62 1.569 1.
= Represents the Gregorian year, month, year, month, year, month, year, month, year, month, year, month, year, month, year (4)
Among them, 0.9702 is the result of 354.36707/365.25, 0.5393 is the result of the total days from New Year's Day to July 16 divided by 365.25, and 622.5393-0.9702 = 621.554366.
Now, the following table lists the calendar year, month and day calculated by two formulas every 100 year from the 52nd Muharram month:
Convert the national calendar to Gregorian calendar
From the calculation results of the table, we can see that the same formula cannot be used in different calendars, otherwise the error will be great. 10 years ago, it was found that the date of vernal equinox in julian calendar was quite different from the measured results, and it was ten days away from the Wanli decade. Therefore, Gregory XIII decided to revise julian calendar. There are two points in the reform. 1. The day after Gregorian calendar 1582 10.04 should be changed from 10.05 to 10.00. Secondly, julian calendar has a leap year every four years and a hundred leap years in 400 years. The Gregorian calendar still maintains the Confucian tradition of a leap year of four years, but only 97 leap years are arranged every 400 years, and there is no leap year every 100 years, and a leap year will be added in 400 years [6]. The chronological facts of julian calendar and Gregorian calendar are as follows:
Confucian calendar (365× 300+366× 00) ÷ 400 years = 365.25 days/year.
Gregorian calendar (365× 303+366× 97) ÷ 400 years = 365.2425 days/year and "Ming history? The * * * palace calendar (solar calendar) included in the calendar is 31 leap in 128 ... >>
Lunar calendar conversion 1990 1222 Gregorian ad 199 1 Wednesday, February 6th.
Lunar calendar 19901February 22nd.
Gan Zhi Xin Wei Niangeng Yin Yue Ding Weiri.
Eight-character Wei Xin Geng Yin Ding Wei Geng Zi
Soil beside the Five Elements Road, pine, cypress, wood, sky, river, wall and soil.
Zodiac sheep
Aquarius