Lunar and solar calendar conversion

What are the rules for converting the lunar and solar calendars? No. The solar calendar is based on the rotation of the earth around the sun. The solar calendar is to the time of the Earth's revolution around the sun (ie: 365 days, 5 hours, 48 minutes and 46 seconds, that is, 365.2422 days) for a year, for the convenience of the calendar as 365 days (known as the year of peace), rounded off 0.2 skeleton 22 days, rounded off by 0.2422 days, every four years adds up to 0.9688 days, nearly a day. Therefore, every four years plus one day, both added to the year can be divided by 4, the year for 366 days (known as the leap year, that is: 29 days in February), every four hundred years less 3.12 days, that is, less than three leap years, so in a hundred years, both to be divided by 4 also to be divided by 400 for leap years. That is, we usually say: four years a leap, not a hundred years, four hundred years again.

The lunar calendar is the time of the moon's revolution around the Earth (i.e., an average of 29 days, 12 hours and 44 minutes) for a month, 12 months a year, 354 days. Every three years there is a leap year, the leap year is 383 days or 384 days. 19 years 7 leap year. In general, 19 years of the solar calendar and the lunar calendar (19 being the number of years) can meet together or only one day difference.

How to convert between Gregorian and lunar calendars The Gregorian calendar, which is internationally recognized. The solar calendar, which is internationally recognized, is based on the time it takes for the Earth to revolve around the Sun, which is 365 days, 5 hours, 48 minutes and 46 seconds. In a normal year, only the whole number of 365 days is counted, without counting the number of days; a year is divided into 12 months, with 31 days in the big month, 30 days in the small month, and only 28 days in the month of February. Four years of the end of the accumulation of ***1 days of light, added to the fourth year of February, this year is called a leap year. Therefore, the month of February in a leap year has 2.9 days. In the lunar calendar, a month is made up of one full and one full moon, and it lasts 29 and a half days. To make it easier to count, the big month is set at 30 days and the small month at 29 days, so that the big and small months roughly alternate among the 12 months of the year. The lunar calendar has only about 354 days in a year, and there is no difference between an equal year and a leap year. The lunar calendar does not take into account the orbit of the earth around the sun, so there is no fixed time for the four seasons in the lunar calendar, and it does not reflect the seasons, which is a great disadvantage. In order to overcome this shortcoming, a compromise calendar was later developed, the so-called lunisolar calendar. The Summer Calendar (also called the Lunar Calendar or the Lunar Calendar by some people), which is still in use in China, is this kind of combined lunar and solar calendar. Like the Lunar Calendar, it also uses the time when the moon is full and the time when the moon is short to make a month, with a big month of 30 days and a small month of 29 days. However, it also uses the method of adding intercalary months to make the average number of days in a year similar to that of the whole year of the Solar Calendar, so as to adjust the four seasons. In the summer calendar, a leap month is added about every two or three years. Lunar Calendar", also known as "Tai Yin Calendar", is based on the fact that the moon orbits the earth for one month, and then the number of hours that the earth orbits the sun for one year, which is actually equal to the yin-yang calendar, which was adopted by our country before the first year of the Republic of China, and was called "Old Calendar" for the sake of being relative to the existing calendar. It was adopted in China before the first year of the Republic of China, and was called the "old calendar" because it was the opposite of the current calendar. People generally think that the lunar calendar is suitable for farmers, and the name of the day "lunar calendar".

The formula for converting the lunar calendar to the Gregorian calendar? There is no direct formula for the two calendars because neither the Gregorian calendar (now the Grecian calendar, which used to be the Julian calendar) nor the Chinese lunar calendar is based on a strict formula.

It is impossible to try to achieve the conversion of the Gregorian calendar with a simple formula without utilizing a lot of data like the almanac (although it can be simplified). All the software we can see for converting the Gregorian calendar has more or less the same amount of calendar data for a number of years.

The most important of these data is the number of days per month in the lunar calendar. Because the lunar calendar is a lunisolar calendar, the lunisolar part (the part organized by the phases of the moon) determines the day of the month, and the solar part (the part organized by the altitude of the sun) is the solar term. The solar term is basically a direct correspondence with the Gregorian calendar, and can be more easily projected; however, the relationship between the lunar cycle and the Earth's rotation is relatively complex, and generally requires astronomical observations to be timed, so there is no simple formula for whether a lunar month is a big month or a small month.

As for the leap in the Gregorian calendar and the lunar calendar, there is a certain way to calculate, and it is not difficult.

If it's just the astronomical data, it's still possible to calculate it - because the astronomical cycle is very stable, and we just have to stick to the astronomical cycle. However, there is a more problematic point, which is that the Gregorian calendar and the lunar calendar are not strictly in accordance with the actual astronomical cycle, and there are many human factors. The most famous ones are the Roman emperors' several revisions of the lengths of the months 2 and 8, and the artificial removal of ten days from the Julian calendar due to inaccurate calculations. Chinese lunar calendar also has because of the ancient astronomical observation inaccuracy caused by *** promulgation of the calendar and the sky does not match (we can not be harsh on the accuracy of the ancient observation). So both calendars are something related to a period of society, and there would be no certain law to follow.

How to convert the Gregorian calendar to a lunar calendar in EXCEL Dim WeekName(7), MonthAdd(11), NongliData(99), TianGan(9), DiZhi(11), ShuXiang(11), DayName(30), MonName(12)

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()

'WeekName

WeekName(0) = *

WeekName(1) = Sunday

WeekName(2) = Monday

WeekName(3) = Tuesday

WeekName(4) = Wednesday

WeekName(5) = Thursday

WeekName(6) = Friday

WeekName(7) = Saturday

'Week name

'Day of the week name

'Day of the week name

'Day of the week name

'Day of the week name

'Heavenly Stem Name

TianGan(0) = A

TianGan(1) = B

TianGan(2) = C

TianGan(3) = Ding

TianGan(4) = E

TianGan(5) = He

TianGan(6) = G

TianGan(7) = Xin

TianGan(8) = Non

TianGan(9) = Dec

'Name of the Earthly Branches'

DiZhi(0) = Zi

DiZhi(1) = 丑

DiZhi(2) = 寅

DiZhi(3) = 卯

DiZhi(4) = 辰

DiZhi(5) = 巳

DiZhi(6) = 午

DiZhi(7) = 未

DiZhi(8) = 申

DiZhi(9) = 酉

DiZhi(10) = Hao

DiZhi(11) = Hai

'Genus Name

ShuXiang(0) = Rat

ShuXiang(1) = Ox

ShuXiang(2) = Tiger

ShuXiang(3) = Rabbit

ShuXiang(4) = Dragon

ShuXiang(5) = Snake

ShuXiang(6) = Horse

ShuXiang(7) = Sheep

ShuXiang(8) = Monkey

ShuXiang(9) = Rooster

ShuXiang( 10) = &q...... >>

How to calculate the lunar and solar calendars Lunar and Solar Calendar Conversion Formula

1, the solar date to calculate the lunar date:

As mentioned above, the lunar date is the moon's rounding as the unit of counting the month, it is the first day of the lunar month for the first day of the lunar month, the moon for the fifteenth day of the lunar month for the fifteenth day of the lunar month for 16th day of the lunar month, the lunar month for the twenty-ninth day of the hi-day of the moon for the thirty-fourth day of the lunar month.

If you want to know what day June 8, 1984 is on the lunar calendar? You can use the formula to calculate the date of the lunar calendar: Set: the number of years - 1977 (or 1901) = 4Q + R

Then: the lunar date = 14Q + 10.6 (R + 1) + the date of the year ordinal number - 29.5n (Note: Q, R, n are natural numbers, R & gt;

Lunar calendar to convert to the Gregorian calendar control table is the Gregorian calendar) Sunday, April 29, 1945

Lunar Solar Conversion 19901222 Wednesday, February 6, 1991 A.D.

Lunar December 22, 1990

Stem Branches Xinwei Year, Geng Yin Month, Ding Wei Day

Horoscope Xinwei Year, Geng Yin, Ding Wei, Hepatitis B

Wuxi Lu Pun Tu (路旁土), Pine Pak Mu (松柏木), Tianhe Shu (天河水), Squash Tu ( 璧上土)

Chinese Zodiac Signs. p>

Chinese Zodiac sign Sheep

Astrological sign Aquarius

How does the lunar and Gregorian calendars convert? (How do you do the math?) Do you have to count orally or with a pen?

I'm telling you, it's not a good idea to do this kind of math, you can't do it at all, the conversion involved is not just a few formulas, on the contrary, it's quite complicated.

If you are interested in writing a program, I can provide a library of conversion functions, call a function to achieve the lunar calendar and the Gregorian calendar conversion.

Currently I have perfected the conversion, so I can provide it if needed.

Conversion of Gregorian and Lunar calendars Conversion back to Gregorian, Gregorian, and Lunar calendars

(128 × 365 + 31) days ÷ 128 years = 365.2421875 days/year

It can be seen that the precision of leap leaping in the *** is much higher than that of the modern Gregorian calendar.

2. Revision of the error of one day in the conversion

Calendar Series takes the year 1387 as an example to calculate the year, month and day of the Gregorian calendar.

Solution 1: 1387 × 0.970224 + 621.5774 = 1967.278088 years

0.278088 years × 365.2422 days = 101.569 days of the Gregorian calendar for the cumulative number of days of 101.57 can be regarded as April 11th or April 12th. Exactly which day, according to the two calendars in the calendar on April 11 or 12 have the same week number to revise.

According to the formula for calculating the number of weeks in the first year of the Gregorian calendar:

[(138-1) × 131 + 164] ÷ 30 = 6057, with a remainder of 20

6057 ÷ 7 = 865, with a remainder of 2

Therefore, New Year's Day of the Gregorian calendar in the year 1387 was the second day of the week (Table)

According to the Gregorian calendar, New Year's Day (Saturday) was the second day of the week in 1583 until 1967, with the remainder of 20. New Year's Day (Saturday) to April 11, 1967, **** calendar:

1967-1583 = 384 years, in the 384 years according to the Gregorian calendar four years a leap, a hundred years without a leap, four hundred years plus a leap day of the rules of the **** calendar 93 leap days, and the day after New Year's Day in 1967 to April 11 and 100 days, then

(384)

(384)

(384)

The New Year's Day of 1387 is week 2 (table). p>

(384 × 365 + 93 + 100 + 6) ÷ 7 = 140359 + 7 = 2001, the remainder of the 2 remainder of the 2 that is, week 2, so the New Year's Day 1387 A.H. in the Gregorian calendar in 1967 on April 11th.

Because of the Gregorian calendar to calculate the number of days of the week using more data, calculations are inevitably omitted, now cited the Gregorian calendar date and the week of the projected table A), for reference.

The application of this table to find the weekly ordinal number of April 11, 1967 A.D. The steps are as follows:

First, in the year table of this table before the two-digit columns, check the location of the word 19;

And then in the two-digit columns of the year after the two-digit columns, check the location of the word 67, the two words from the word 19 parallel to right, the two words of the word 67 vertically downward, the two in the English capital letter

And then from the month table column to April, from the location of April parallel to the left, to find the location of G in the April column;

From the date column to the location of the 11th, from the location of parallel to the right, so that the intersection with the April column G in the day of the week table for Tuesday, the result is the same as the calculation of the Gregorian calendar. Therefore, the New Year's Day of 1387 A.D. is indeed April 11, 1967, not the 12th.

In the conversion, the number of days in the Gregorian calendar is often more than 31, or even 200-300 days or more, which needs to be converted into months and days of the year, the following two tables can be used.

Table 3 Calendar months and their cumulative number of days

III Conversion of the Gregorian calendar to the Gregorian calendar

Conversion of the Gregorian calendar to the Gregorian calendar is shifted, and can be obtained by organizing the Gregorian calendar to the Gregorian calendar

(Gregorian calendar year 1.621.5691)÷0.9702 = Gregorian calendar year, month, and day (Julian calendar) ... .............................. ..................(5)

(Gregorian calendar year 1 621.5774) ÷ 0.970224 = Hijri year and month (Gregorian calendar) .............................. .................. (6)

Whether the Gregorian calendar is converted to the Gregorian calendar or vice versa, there is roughly a one-day difference, and in the case of revision by the ordinal number of the week, the Gregorian calendar is converted to the Gregorian calendar by the ordinal number of the week in the Gregorian calendar. In the case of the revision of the days of the week, when the Gregorian calendar is converted to the Gregorian calendar, the days of the week of the Gregorian calendar prevail.

4 National or Gregorian Calendar to Chinese Lunar Calendar

1. Conversion of Gregorian Calendar to Lunar Calendar

Although the number of months and days in each year of the Chinese Lunar Calendar is not a relatively stable value, which makes the conversion of Gregorian Calendar to Chinese Lunar Calendar difficult, it is still possible to convert it. Chinese Lunar Calendar is a yin and yang calendar, which belongs to the same yin calendar as the Gregorian calendar in terms of months, but the Gregorian calendar starts each month with a new moon as the beginning of January, which is about 1-2 or even 3 days later than the Gregorian calendar's first day of the lunar year, so as long as we can find out the relationship between the two in terms of months, the Gregorian calendar can be converted into the Chinese Lunar Calendar. According to Mr. Ma Yiyu: "...... >>

How do I convert from the lunar calendar to the solar calendar? The first day of the month is called Shuo (朔) and the last day is called Hsi (晦). The fifteenth or sixteenth or seventeenth day of the lunar calendar is called Wang, and the day after Wang is called Meishang (既望). So the Chinese New Year's Eve doesn't fall on the same day every year. The lunar calendar is based on the "return year" and the "lunar month". The "regression year" is the time it takes for the sun to pass through the equinoxes twice in a row, i.e. 365.2422 days (365 days, 5 hours, 48 minutes and 46 seconds). The "lunar month" is the time it takes for the Moon to pass through the equinox twice in a row, i.e. 29.5306 days (29 days, 12 hours, 44 minutes and 3 seconds). Since there are only 354.3672 days in the 12 lunar months, which is more than 10 days different from the 365.2422 days in the "return year", the difference is accumulated and becomes a leap month. As early as the Spring and Autumn Period (500-600 BC), the Chinese calendar adopted the arrangement of seven leap months in nineteen years. However, the Chinese lunar calendar and the *** lunar calendar as well as the Korean lunar calendar do not calculate the leap months in the same way, and there is usually a difference of one or two days. The lunar calendar uses the moon's waxing and waning as the unit of measurement, with the first day of the lunar month being the first day of the month, the fifteenth day of the lunar month being the fifteenth day of the lunar month (the sixteenth day of the lunar month), and the twenty-ninth day of the lunar month being the twenty-ninth day of the lunar month (the thirtieth day of the lunar month). However, at present, timekeeping is usually expressed in the solar calendar date, such as the desire to convert the solar calendar date to the lunar calendar date can be used in the following two ways: one is to check the "new almanac", such as checking the June 8, 1984 is the lunar calendar date? Turn over the almanac June 10 is the eleventh lunar calendar, then reverse June 8 is the ninth lunar calendar. The second can use the formula to deduce the lunar date: Set: the number of years AD - 1977 (or 1901) = 4Q + R then: lunar date = 14Q + 10.6 (R + 1) + the date of the year ordinal number - 29.5n (Note: Q, R, n are natural numbers, R )