Conversion between lunar calendar and solar calendar

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

How are the solar and lunar calendars converted? 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, China calendar adopted the arrangement of seven leap months in 19 years.

However, the calculation method of China lunar calendar is different from that of * * * and Korean lunar calendar, which is generally one or two days apart.

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: the number of AD years-1977 (or1901) = 4q+r.

Then: Lunar date =14q+10.6 (r+1)+date ordinal of the year-29.5n.

(Note: Q, R and N in the formula are all natural numbers. R 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.

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.

Gregorian calendar 19740820 what is the conversion of the lunar calendar (Gregorian calendar):1974 August 20th.

Lunar calendar: the third day of July in Jiayin year.

I don't know much about the programming of lunar conversion algorithm.

Pass on the formula.

Multiply by five and divide by four and nine days.

The interval between two months is thirty days.

One, two, plus one, minus one,

The top ten tails of 3578.

The specific algorithm can be found online. There is a lot of information on Baidu, so I won't go into details.

What is the lunar calendar 19970205 converted into the solar calendar? 3. 13

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.

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