How to calculate the year, month and day

How does excel calculate the date between two dates = datedif (A2, B2, Y)&; Year and Date (A2, B2, YM) Month and Date (B2 A2, Maryland) Sky

As shown below, enter the above formula in C2 and pull it down!

Question 2: Calendar method? How did the ancients calculate the date? Ask a question

log in

register

?

Please enter a keyword.

Download now

? subject

How to calculate the time in ancient China?

How is the year, month and day calculated?

Style 47612014-12-09

Baidu homework help-what is it? Let me tell you something.

Excellent solution

As early as 2697 BC, when the Yellow Emperor, the ancestor of China, founded the country, heavenly stems and earthly branches made a great fuss about exploring the qi of heaven and earth and the five elements (water, fire and earth in Jin Mu), and started the ten-day work of A, B, C, D, E, Ji, G, Xin, Ren and Gui, and the work of Zi, Ugly, Yin, Mao, Chen, Si, Wu and Gui.

In the China calendar, the time for the moon to go around the earth once (29.5306 days) is January, and the time for the earth to go around the sun once (365.809 days) is one year. In order to make the average number of days in a year consistent with the number of days in the tropical year, leap months were set up. According to records, in the 6th century BC, China began to adopt the method of 19 years and seven leap months to coordinate the lunar calendar with the solar calendar.

Heavenly stems and earthly branches is a symbol designed in the past to facilitate the production of 60-digit calendars. For ancient China people, the existence of heavenly stems and earthly branches was as simple as * * * numbers. Later, these symbols were applied to maps, directions and time (time axis and space axis), so these numbers were endowed with more and more meanings.

The ancients (talking about the Yellow Emperor) observed the moon of Wang Shuo and found that the two moons of Wang Shuo were about 59 days. 12 Wang Shuo's moon is usually more than 354 days (similar to the length of a tropic year), so the ancients got the concept of 12 months in a year. In the method of keeping a diary (ten-day work), a kind of heavenly stems and earthly branches's lunar calendar was produced and developed. It should be more mature in Xia, Shang and Zhou Dynasties.

Heavenly stems and earthly branches, abbreviated as Ganzhi, is used to arrange the year and date in the summer calendar.

The calendar uses heavenly stems and earthly branches to arrange year numbers and dates, and the heavenly stems are crosses, so it is also called "ten stems". The order of arrangement is: A, B, C, D, E, Ji, G, Xin, Ren and Gui; The twelve characters of the earthly branches are arranged in the following order: Zi, Ugly, Yin, Mao, Chen, Si, Wu, Wei, Shen, You, Xu and Hai. Among them, A, C, E, G and Ren are dry in the yang, while B, D, J, Xin and Gui are dry in the shade. Son.

A trunk and a branch are arranged in a matching way. The trunk starts from A, the branch starts from Zi, and the trunk is opposite to Yang, and the trunk is opposite to Yin (the trunk doesn't match the branch, and the trunk doesn't match the branch), so the 60-year cycle is called "Sixty Jia Zi" or "Flower Jia Zi". In the past, Chinese people used to record the year with the cycle of sixty years.

Question 3: How are the years, months, days and hours calculated? The latest fast calculation method of year, month, day and hour.

First, the method of quickly calculating the trunk and branches of the annual column

Dry days and dry things:

1(A)； 2(b)； 3(c)； Article 4 (d); Article 5 (e); 6 (self); Article 7 (g); 8 (symplectic); 9 (nonyl); 10 (decyl)

Grounding branch:

Press1(sub); 2 (ugly); 3 (yin); Article 4 (d); 5 (Chen); 6 (4); 7 (noon); 8 (no); 9 (Shen); 10 (unitary); 1 1 (?); 12 (sea)

Calculate sky dryness:

Any year after A.D.: A.D. -3= the number of digits at the end of the year, negative number plus 10.

Any year BC: year-end digits +8= year-end.

(The formula reveals: Because AD 3 is the year of Guihai, and the heavenly stems are the cycle of 10. In AD 4, the heavenly stems were a, 4-3= 1. Because there is no year 0, the heavenly stems in BC are the last digit-3+1,and then+10 becomes a positive number)

Computational Earth Branch:

Any year after A.D.: (A.D. year -3)÷ 12, the remainder 0- 1 1 is the annual branch, and the negative number is added with 12, and 0 is regarded as 12.

Any year in BC: (AD year -2 years) ÷ 12, and the remainder-1-0 is the annual branch. Add 12 to make it a positive number, and 0 is regarded as 12.

(Formula revealed: similar to the above)

In addition:

Year-end 2 digits +9= annual expenditure (applicable to1800-1899);

2 digits at the end of the year+1= annual expenditure (applicable to1900-1999);

3. Two digits at the end of the year +5= annual expenditure (applicable to 2000- 1999);

Description:

Note: beginning of spring is the boundary between the main branches of a year, not the Spring Festival. For example, whether February 4th 1964 of the lunar calendar is1February 2nd1day or the first year of the lunar calendar; However, although February 5th of the lunar calendar, 1964 Gregorian calendar is1February 22nd, this day is already in beginning of spring, which is an appropriate year for Chen Jianian.

Example 1: find the annual dry of this column in 7 BC: annual dry =-7+8= 1, that is, a; Annual branch =(-7-2)÷ 12=-9, plus 12 to a positive number of 3, that is, Yin. So 7 BC is Jiayin year.

Example 2: Find the annual stem and branch in 2000: annual stem = last digit 0-3=-3, plus 10=7, that is, Geng. Annual expenditure =00+5=5, which is Chen. Therefore, 2000 is the year of Chen Geng.

Example 3: Find the annual stem of 1999: annual stem = the last digit 9-3=6, that is, itself; Annual branch = last two digits 99+ 1= 100 minus 8 12, and the remaining 4 is gross. So 1999 is the first year.

Note: The branches and branches of the lunar calendar corresponding to a solar calendar year correspond to most of the time in a year, but they are not completely coincident.

Second, the method of quickly calculating the stem and branch of the moon column

1. Calculate the dryness of the sky: annual dryness x2+ months = monthly dryness; If it exceeds 10, subtract 0-9 from the multiple of 10, and 0 is regarded as 10).

(formula revealed: since the first month of Jiazi year is March of the lunar calendar, that is, A 1 corresponds to C 3, it is calculated that the first month of the second ugly year is Wuyin, that is, B 2 corresponds to E 5, and then C 3 corresponds to G 7, which is just the first month of the year. x2+ 1)2。 Calculate the earthly branch: the monthly branch of the lunar calendar is fixed.

Since the Shang calendar, the first month of each year has been designated as Yin, which is called "building Yin in the first month", and the subsequent months are analogized in the order of earthly branches. The calculation method of the first month is:

If:

When you meet A or your own year, the first month is C Yin; B or Geng Year, the first month is Wuyin;

In the year of C or Xin, the first month is Geng Yin; Ding Nian or Ren Nian, the first month is Renyin;

In the year of 1898 or Guisi, the first month was Jiayin. The first month is calculated according to the main branch, and other months can be calculated according to the main branch.

The first month is a cloudy month (from the day of beginning of spring to the day before the fright), and the second month is a cloudy month (from the day of the fright to the day before Tomb-Sweeping Day).

March is Chen (the day before from Qingming to long summer) and April is Si (the day before from long summer to busy).

May is noon (from the day before the awning to the day before the summer heat), but June is not (from the day before the summer heat to the day before beginning of autumn).

July is Shen (from the day of beginning of autumn to the day before the Millennium), and August is especially (from the day before the Millennium to the day before the cold dew).

September (the day before the cold dew arrives in beginning of winter) and October (the day before the start of winter to the day before the heavy snow),

November is the child (from the day of heavy snow to the day before slight cold), and December is ugly (from the day before slight cold to the day before beginning of spring).

Note: The monthly branches and branches are based on festivals, not the first day of each month in the lunar calendar. Before the festival is the festival of last month, and after the festival is the festival of next month. Therefore, the branches and branches corresponding to a lunar year correspond to most of this month, not completely overlapping.

Example 1: Gregorian calendar February 3, 2008 >>

Question 4: How to calculate the year, month, day and hour with heavenly stems and earthly branches? Chronology of ancient China. That is, Party A, Party B, Party C, Party D, Party E, Party B, Party G, Party A, Party B and Party B are ten, while Party A, Party B, Party C, Party B, Party C, Party D, Party B, Party B and Party B are twelve, and the branches are coordinated in sequence. Such as Jia Zi and Yi Chou, will return to Jia Zi after 60 years. It goes on and on. In China, the lunar calendar still uses the calendar year of cadres and branches.

The chronology of the dry branch sprouted in the Western Han Dynasty, began with Wang Mang, and prevailed in the late Eastern Han Dynasty. In the second year of Emperor Yuanhe of the Han and Yuan Dynasties (AD 85), the court ordered the nationwide implementation of the chronicle of cadres. Some people think that China used dry branches to record the years before Emperor Wu of the Han Dynasty. However, this is the Gregorian calendar year of the Prince, which is based on the Gregorian calendar year of the Prince, and the branch represents twelve days (the ecliptic is divided into twelve equal parts). Jupiter 1 1.862 revolves around the sky once a week, so it takes about 86 years for Tai Sui to pass through an old age, which is the so-called "Chen Chao". In the Calendar of Zhuan Xu, the first year of Tai Chu (BC 104) of Emperor Wu of the Western Han Dynasty was the prince of Bingzi, and taichu calendar changed it to Ding Chou by surpassing Chen. At the end of the Han Dynasty, Liu Xin changed the first year of Taishu to Bingzi, and the second year of Taishi (the first 95 years) from Yiyou to Bingxu. Scholars who returned to the eastern Han dynasty did not use the super-Chen method. So from the second year, the chronology of the prince and the chronology of the main branch are the same. However, according to legend, the chronology expressed by heavenly stems and earthly branches began in the period of the Yellow Emperor, and 60 pieces of Jiazi table were found in Shang Dynasty archaeology in Yin Ruins.

1. The meaning of trunk and branch: trunk and branch are the general names of heavenly stems and earthly branches.

Dry refers to heaven, * * * with 10 symbol:

1 2 3 4 5 6 7 8 9 10

Methyl ethyl propyl butyl hexyl heptyl octyl non decyl

Refers to the earth, * * * with 12 symbol:

1 2 3 4 5 6 7 8 9 10 1 1 12

The child is ugly, and the mother hasn't applied this afternoon.

2. The combination of stem and branch is used for dating. That is to say, the ten-day stem and the twelve-day branch are combined to form the stem and branch for dating. According to this arrangement method, 60 branches can be formed after six rounds of arrangement 10 symbols and five rounds of arrangement 12 symbols for ground branches on the same day. If it continues to be discharged, it will return to its original state again and again, which is what the folks call "sixty years of turning to Jiazi".

[Edit this paragraph] Sixty years Jia Zi (branch table)

1 2 3 4 5 6 7 8 9 10

Jia Chubing Yin Dingmao Wu Renshen Gui You

1 1 12 13 14 15 16 17 18 19 20

Jia Haibing Zi Ding Chou Mao Xin Si Ren Wu Guiwei

2 1 22 23 24 25 26 27 28 29 30

Shen Jia Yi Youbing Xu Ding Wu Haizi ugly Geng Yin Xin Mao Renchen ghost silk

3 1 32 33 34 35 36 37 38 39 40

Wu Jia translated Shen Dingyou, the Reform Movement of 1898, and Ji Haigeng rewarded Ren Yin Guimao.

4 1 42 43 44 45 46 47 48 49 50

Chen Jia, Bess, Bing Wuding, Wu Shen, Ji You, Geng Xu, Xin Hai, Ren Zi, Gui Chou.

5 1 52 53 54 55 56 57 58 59 60

Jia Yin, Yi Mao, Chen Bing, Ding Si, Wu Wu and Xin You have not applied for this position, and they have all failed.

[Edit this paragraph] Understand the "Twelve Branches" in combination with the actual situation

1. Match twelve animals with twelve earthly branches to form the Year of the Zodiac. (See the picture below) If the year of the main branch contains the word "zi", it is the year of the rat, and all the people born in this year are "rats"; The Year of the Ox is a year of ugliness, and all the people born in this year belong to the ox. And so on. (as shown in the following table)

Zodiac year

1 2 3 4 5 6 7 8 9 10 1 1 12

Rat, ugly cow, black snake, black horsetail, Yang Shen Houyou chicken, Gou Haizhu

2. Twelve branches represent twelve o'clock.

There are twenty-four hours in a day, but in our tradition, it is represented by twelve hours, that is, one hour is two hours. (as shown in the following table)

24-hour and 12-hour comparison table

Ugly son, ugly son, ugly son, ugly son.

23-0 1:0 1-03:03-05 :05-07:07-09:09- 1 1

At noon, I didn't apply.

1 1- 13: 13- 15: 15- 17: 17- 19: 19-2 1:2 1-23

......& gt& gt

Question 5: How does Japan calculate 10 minutes on a day of the month? Calendar is a calendar used in Japan, and the China lunar calendar was used before. Use China's Yuanjia calendar, Linde calendar (called Yifeng calendar in Japan), Dayan calendar, five-year calendar and Xuan Ming calendar. After that, I used the Japanese-made xiangzhen calendar, Polly calendar, Kuanzheng calendar and Tianbao calendar alone. 1868 After the Meiji Restoration, 1873 Tianbao calendar was abolished, and the Gregorian calendar was replaced, and the old calendar was abolished. However, folk divination, fortune telling and vernal equinox burial are still in accordance with the Tianbao calendar.

Year number year

The only difference between Japanese calendar and Gregorian calendar is chronology. Japanese still adopt the chronology of Empress China, and every new emperor will change the chronology when he ascended the throne. For example, 2008 is the "20 years of Heisei" of Emperor Akihito. At present, due to the increase of international communication, the year number is also used in commerce and diplomacy, but the year number of the emperor is still used in coin printing and official letters.

Segmented sentence

Festivals introduced into Japan from China are called "festivals". In ancient times, they followed the custom of China, and the date was calculated according to the lunar calendar. Now in Japan, the date is changed to Gregorian calendar.

New Year's Day-New Year's Day/January/January. Gregorian calendar 65438+ 10 month 1.

Men's Day-seven grass の sentence (seven grass Festival). Gregorian calendar 65438+10.7.

Shangsi-Taoの Festival (Cherry Blossom Festival)/Young Sacrifice (Daughter's Day). Gregorian calendar March 3.

Dragon Boat Festival-Dragon Boat Festival/Zigong Day (Children's Day). May 5 of Gregorian calendar.

Tanabata-Tanabata. July 7th of Gregorian calendar.

Double Ninth Festival-Chrysanthemum Festival. Gregorian calendar September 9.

Miscellaneous knot

Japan's own festivals that follow the 24 solar terms are called miscellaneous festivals.

The day before the festival, beginning of spring. Around February 3rd.

The other shore-1 week includes vernal equinox and autumnal equinox.

Social Day-May Day closest to the vernal equinox and autumnal equinox.

Eighty-eight nights-eighty-eight days from beginning of spring. Around may 2 nd.

Into the plum blossom-the day when the sun passes the yellow meridian at 80. Around June 1 1.

Pinellia ternata was born-the day when the sun passed through the Yellow Meridian at 100. Around July 2.

Soil use-generally only refers to soil use in summer.

Land use in spring: from 27 degrees of the yellow longitude to long summer (45 degrees of the yellow longitude)

Soil used in summer: from longitude 1 17 to beginning of autumn (longitude 135).

Autumn soil use: from longitude 207 degrees to beginning of winter (longitude 225 degrees)

Winter soil: from longitude 297 degrees to beginning of spring (longitude 3 15 degrees).

Beginning of spring 200 days 2 10 days. Around September 1.

220 days-220 days after beginning of spring. Around September 1 1.

Question 6: If you know a date in excel, how can you use the function to calculate the year 1? You can see through the years directly with the PivotTable report.

2. If the current date is in column B, you can use the function YEAR(B 1) in column C, and then drop it down, so you can just use the year directly.

I hope it helps you.

Question: How does excel calculate the month between two dates? Assuming that two dates are in cells a 1 and b 1 respectively, the formula is:

=DATEDIF(A 1，B 1，m)+DATEDIF(A 1，B 1，md)/30

Or use the formula:

=DATEDIF(A 1，B 1，d)/30

Or:

=(B 1-A 1)/30

Question 8: Enter the year, month and day and calculate the date of a year (note leap year in normal years). How to compile C language programming? #includeint main(){ int Total = 0，Day = 0，Month = 0，Year = 0，Leap = 0； Printf (please enter: MM DD YY \ n); Scanf(%d %d %d, & year & month & day); Switch (month) {case1:total = 0; Break; Case 2: Total = 31; Break; Case 3: Total = 59; Break; Case 4: Total = 90; Break; Case 5: Total =120; Break; Case 6: Total =151; Break; Case 7: Total =181; Break; Case 8: Total = 212; Break; Situation 9: Total = 242; Break; Case 10: total = 273; Break; Case 1 1: total = 303; Break; Case 12: total = 334; Break; Default value: printf (error \ n); Break; } total = total+days; if(Month & gt； 2 & ((year% 4 = = 0 & amp& amp year% 100! = 0) || (year% 400) = = 0) {leap =1; } Total = Total+Leap； Printf(%d:%d:%d is %d days \n, year, month, day, total); Returns 0; If you don't understand this, it's simple as follows.

# includeMain () {while (1) {int year, month, day, time, m; Printf (please enter: MM DD YY \ n); Scanf(%d %d %d, & year & month & day); Switch ((year% 4 = = 0)&; & (year% 100! = 0))| |(year % 400 = = 0)){ case 1:{ switch(month){ case 1:time = day； Break; Case 2: Time = 3 1+ days; Break; Case 3: Time = 3 1+29+ days; Break; Case 4: Time = 3 1 * 2+29+ days; Break; Case 5: Time = 3 1 * 2+29+30+ days; Break; Case 6: Time = 3 1 * 3+29+30+ days; Break; Case 7: Time = 3 1 * 3+29+30 * 2+ days; Break; Case 8: Time = 3 1 * 4+29+30 * 2+ days; Break; Case 9: Time = 3 1 * 5+29+30 * 2+ days; Break; Case 10: Time = 3 1 * 5+29+30 * 3+ days; Break; Case 1 1: Time = 3 1 * 6+29+30 * 3+ days; Break; Case 12: Time = 31...>>

Question: There is a date of birth in Excel. How to calculate your age with a formula? =DATEDIF(A 1, today (), y)