Gregorian calendar lunar conversion

The Gregorian calendar is changed from the lunar calendar to the Gregorian calendar, which is internationally accepted. According to the Gregorian calendar, it takes one year for the earth to revolve around the sun, totaling 365 days, 5 hours, 48 minutes and 46 seconds. The average year is only an integer of 365 days, not a mantissa; A year is divided into 12 months, big month 3 1 day, small month 30 days, and February only has 28 days. The mantissa of four years is accumulated to 1 day and added to February of the fourth year. This year is called leap year. So February in leap year has 2 9 days. The lunar calendar orders a full moon for one month, a total of 29 and a half days. For the convenience of calculation, the big month is 30 days and the small month is 29 days. In 12 months of a year, large and small months are generally arranged alternately. The lunar calendar has only about 354 days a year, and there is no difference between a normal year and a leap year. The lunar calendar does not consider the movement of the earth around the sun, so the changes of the four seasons in the lunar calendar have no fixed time and cannot reflect the seasons, which is a great shortcoming. In order to overcome this shortcoming, people later decided on a calendar called Yin-Yang calendar. The summer calendar still in use in China (some people call it lunar calendar or lunar calendar) is this kind of lunar calendar. Like the lunar calendar, it is also based on the bright and full time of the moon to customize a month, with a big month of 3 0 days and a small month of 29 days. However, it also adopts the method of adding leap months to make the average number of days in a year close to the number of days in the solar calendar to adjust the four seasons. Every two or three years, there will be an extra leap month in the summer calendar. The lunar calendar, also known as the lunar calendar, takes the moon's orbit around the earth as one month and the earth's orbit around the sun as one year, which is actually equal to the lunar calendar. This calendar was adopted in China before the first year of the Republic of China, so it is called the old calendar. Generally speaking, the lunar calendar is suitable for farmers and is named "Lunar Calendar".

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 the ancient solar calendar and lunar calendar The Chinese calendar has been a kind of lunar calendar since ancient times. Because the first day of each month is a new moon and the fifteenth day is a full moon, it is easy to identify and use, so it is usually called the lunar calendar. Until today, due to the change of solar terms in the calendar, it is closely related to agricultural planting activities, and the "Lunar Calendar" plays an important role in the lives of China people, especially farmers.

First of all, you said that "the ancient people in China used the lunar calendar". This statement is not very accurate.

Now, we call the AD calendar "solar calendar", because when this calendar was introduced into China, we called our traditional calendar "lunar calendar".

In fact, "lunar calendar" and "lunar calendar" are not the same concept. The lunar calendar mainly refers to the system of 24 solar terms, "Sanjiu" and "Sanfu" summarized by farmers according to the needs of agricultural production and life. The system combines the specific conditions of various regions and industries, and contains rich and practical contents. In today's words, this is a very scientific and thorough calendar system, which fully shows the great wisdom of the working people in ancient China. This is recognized in relevant international fields.

Lunar calendar is a chronology used by ancient officials in China to record and narrate history. This chronology is basically stupid. Because it is not based on the activities of the sun, but on the activities of the moon. In fact, there is no doubt that the sun is much bigger than the moon in terms of its influence on human beings. The four seasons of the lunar calendar do not always accurately represent natural conditions, so we have to adjust them through leap years and leap months. What's more, because there is no unified long-term chronology standard, it will be very difficult to describe history. For example, when people in the Ming Dynasty talked about the Tang Dynasty, they said, "During the Zhenguan period of the Tang Dynasty, Wu Jia (or Jiayin, etc.). ) years ". If the former Qin Dynasty is involved, it will be no ordinary trouble. What is the relationship between "Qi Mou Gong Moumou" and "Chu Mou Wang Moumou"? There are not many countries in the country that can figure it out.

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 when encountering a 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.

The comparison table for converting the lunar calendar into the Gregorian calendar is Gregorian calendar1Sunday, April 29th, 945.

How to convert the lunar calendar into the Gregorian calendar is Gregorian calendar 165438+ 10/3. There are days in this calendar. If you want to know how to change it, of course, the Gregorian calendar is fixed. 1, 3, 5, 7, 8, 10, 12 are all days of 3 1, and February 28th (once every four years, as in 2008.

For the lunar calendar, its essence is the lunar calendar, and it follows the lunar calendar, which is a very complicated astronomical knowledge. It includes 24 solar terms.

Remember that the solar calendar is 1, 3, 5, 7, 8, 10, La, 3 1 day, and the rest are 30 days, except February 28th.

If the leap month is February 29th, there will be only one more day.

How to convert Gregorian calendar into lunar dimweek name (7), monthly addition (1 1), nonglidata (99), heavenly stems (9), earthly branches (1 1) and book fragrance (160) in EXCEL?

Dim curTime、curYear、curMonth、curDay、curWeekday

Dim GongliStr，WeekdayStr，NongliStr，NongliDayStr

Dim i，m，n，k，isEnd，bit，TheDate

Private Sub-Form _Load ()

Get the current system time

curTime = Now()

Name of the week

WeekName(0) = *

Day Name (1) = Sunday

WeekName(2) = Monday

WeekName(3) = Tuesday

WeekName(4) = Wednesday

WeekName(5) = Thursday

WeekName(6) = Friday

WeekName(7) = Saturday

Tianganming

Tiangan (0) = a.

Tiangan (1) = b.

Tiangan (2) = C.

Tiangan (3) = d

Tiangan (4) = E

Heavenly stems (5) = self-nature

Tiangan (6) = Geng

Tiangan (7) = Xin

Tiangan (8) = Ren

Tiangan (9) = decyl

Name of earthly branch

DiZhi(0) = child

Di Zhi (1) = Ugly

Ground straight (2) = Yin

Di Zhi ③ = Mao

Di Zhi (4) = Chen

Ground level (5) = Si

Ground straight (6) = noon

Di Zhi (7) = No.

Di Zhi (8) = Shen

Ground straight (9) = unitary

Vertical (10) = 0

Di Zhi (1 1) = sea

Animal constellation name

Shuxiang (0) = mouse

Shuxiang (1) = Niu

Shuxiang (2) = Tiger

Shuxiang (3) = Rabbit

Shuxiang (4) = Dragon

Shuxiang (5) = Snake

Shuxiang (6) = Ma

Shuxiang (7) = Sheep

Shuxiang (8) = Monkey

Shuxiang (9) = Chicken

Shuxiang (10) =&; q......& gt& gt

How to convert China's solar calendar, lunar calendar and solar calendar in dates? Baidu is too complicated to study by itself.

How to convert the lunar calendar into the solar calendar? The first day of each month is called the new moon, and the last day is called darkness. The fifteenth, sixteenth or seventeenth day of the lunar calendar is called Wangwang, and the day after Wangwang is called Wangwang, so the New Year's Eve of the lunar calendar is not the same day every year. The basis of the lunar calendar is the year of the tropic of Capricorn and the first month. The tropic year is the time required for the sun to pass through vernal equinox twice in a row, that is, 365.2422 days (365 days, 5 hours, 48 minutes and 46 seconds). "The first month of the lunar calendar" is the time between two consecutive new moons (new moons) or two full moons (full moons), that is, 29.5306 days (June 29th 12 hours, 44 minutes and 3 seconds). Because 12 "Wang Shuoyue" is only 354.3672 days, which is more than 10 days different from 365.2422 days in the tropic year, this difference adds up to a leap month. As early as the Spring and Autumn Period in 5600 BC, the calendar of China adopted the arrangement of seven leap months in 19 years. However, the calculation method of China lunar calendar is different from that of * * * and South Korea, with a general difference of one or two days. The date of the lunar calendar is based on the full moon, and each new moon is the first day. The full moon is 15th (16th) and 29th (30th). However, at present, the date of the solar calendar is usually used to express the time. If you want to convert the date of the solar calendar into the date of the lunar calendar, you can use the following two methods: one is to search the newly edited perpetual calendar, for example, what is the date of the lunar calendar on June 8, 1984? Open the perpetual calendar, 10 June is the eleventh lunar month, so it is inferred that June 8 is the ninth day of the ninth lunar month. Secondly, we can use the formula to calculate the lunar calendar date: suppose: AD year-1977 (or 190 1) = 4q+r, then: lunar calendar date =14q+10.6 (r+ Secondly, heavenly stems and earthly branches is mostly used for folk fortune-telling and word-testing, with a strong superstitious color, which is really incompatible with modern science and technology society. But an excellent nation will not abandon its own history and culture. In historical events, poems, calligraphy and painting, there are a lot of chronicles of heavenly stems and earthly branches, so we need to know and be familiar with him. Let's take a look at it a little: 1. The origin of heavenly stems and earthly branches is called "trunk" for short in heavenly stems and earthly branches, and heavenly stems and earthly branches is equivalent to trunk and leaves. They are an interdependent and coordinated whole. In ancient China, heaven was the "master" and the earth was the "slave". The interconnection between "heaven" and "dryness" is called "heavenly dryness"; The relationship between "earth" and "branch" is called "earth branch", which together is "heavenly stems and earthly branches". There are ten words for heavenly stems, which are always called "ten heavenly stems". There are twelve characters in the earthly branches, which are collectively called "Twelve Earthly Branches". In the original meaning of heavenly stems and earthly branches, there is an interesting saying: 1, heavenly stems (A) sprout like grass forest, and the sun is covered with shade. Others think that the armor of armor also highlights everything by breaking through its armor. (b) The vegetation is primary, with soft, elastic and slender branches and leaves. The second one is rolling. (C) C, C, like the bright sun, scorching fire, everything belongs to Ming Che. (d) vigorous, vegetation grows vigorously, just like a person's maturity. (e) Mao Ye symbolizes the lush vegetation on the earth. From (since), discipline is also, everything turns back, tangible and disciplined. (g) More importantly, the autumn harvest should wait until spring. (Xin) Jin Weixin, when things are done, they will taste. Others believe that the new is also new, and they are in awe of all changes and show new achievements. Pregnancy, when everything is pregnant, the sun is an elf lurking underground. (1) Yes, everything is hidden, gestated, underground and budding. 2, the ground branches (seeds) are also awkward, flowers and trees have children, and the water in the soil is sucked out, which is the beginning of a yang Meng. (Ugly) Cattle fields, where vegetation germinates, bends and leaves the ground. Swallow leaves, gold leaves, flowers and trees that bend in cold soil protrude from the ground to meet the spring day. (Ye Mao), Rizhao East, everything is thriving. (Chen) The earthquake also extended that everything was born from the earthquake, and the sun was over half. (3) Everything begins to grow, yin disappears, and pure yang has no yin. (noon) Hey, everything is full and full, the yang is full, and the yin is budding. Delicious (not delicious), ripe fruit is delicious. (Shen) Both the body and the object have grown up. You are still alive when you are old, and everything is still shrinking and converging. Extinction, vegetation withers, anger goes out. (sea) illegal, illegal killing, has reached the extreme. Heavenly stems and earthly branches is said to have been invented in ancient times four or five thousand years ago. For example, Liu Shu in the Tang Dynasty quoted an ancient book and said, "(The Yellow Emperor) made great efforts to govern …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………… At first, our ancestors only used the sky to record the days, because the days of a month were carried by the days; Remember the months with earthly branches, because ten months in a year exactly match ten earthly branches. However, not long after, people think that there will still be three days in a month to record the days only by the sky. Therefore, a heavenly stem and a earthly branch are used to record dates in turn, such as Shangshu. Gu Ming says, "Only April is full of life. Kings don't make choices. Jia Zi, Wang Nai Tao Zanshui, was crowned with clothes. According to the records, this means that in early April, Wang felt very uncomfortable. On Jiazi's day, Wang Cai washed his face, the servant dressed the king, and Wang Yi sat on the jade table. Later, the method of recording the day was gradually introduced to record the year, month and time. Sixty flowers Jia Zi China lunar calendar uses heavenly stems and earthly branches as the method to calculate the year, month, day and time, that is, each heavenly stems and earthly branches is paired in a certain order, without repetition, as the code of the year, month, day and time. Put a word in the front "heavenly stems" and a word in the back "earthly branches", thus forming a pair of stems and branches. If "Tiangan" starts with "A" and "Dizhi" starts with "Zi", we can get: 1. Jiazi 2. Picnic 3. Bing Yin 4. Ding Mao 5. Chen Wu 6. Jiu Si 7. Wu Geng 8. Xinwei 9. Ren Shen 10. & gt