-
Anonymous users2024-02-07You only need to figure out what the lunar calendar is about, and you can calculate it yourself!
-
Anonymous users2024-02-06b2="Lunar calendar"&text(a2,"[$-130000]m month d"- Limited to 2007 version and above.
The leap month of the lunar calendar will add 1, such as July will show August, and August will be postponed to September....December was postponed to December.
b2=lookup(--substitute(substitute(a2,-30,-28),-29,-27),-text((left(a2,5)&"1/1")+row($1:$400),"[$-130000]yyyy/m/d"),(left(a2,5)&"1/1")+row($1:$400))+right(a2,2)>28)*2
Check: c2="Lunar calendar"&text(b2,"[$-130000]m month d")
-
Anonymous users2024-02-05Yes, I have it here, it's a plug-in, which can realize interversion, which is very powerful.
Passcode: 699i
-
Anonymous users2024-02-04For example, today is September 2, 2010, and the 24th day of the seventh lunar month can be obtained by the following formula
Although the results are a bit unsatisfactory when encountering a leap month, as shown in the figure below, the lunar calendar on February 9, 2010 should be December 26, but because there was a leap month in that year, there was an extra month. But it's much faster than making up **, and leap months don't happen every day.
If you change the formula to: =mid("A, B, C, D, 戊, Ji Geng, Xin Ren, Guizi, Chou Yin, Mao Chen, Si Wu, Wei Shen You, Xuhai",mod(text(a2,"[$-130000]e")-4,12)+1,1)&"The tenth day of the first month of the year",if(--text(a2,"[$-130000]d")>10,"[$-130000][dbnum1]d","Chu[$-130000][dbnum1]d"It's more like the lunar notation, but because the start date of the lunar calendar is different every year, it is difficult for the function to achieve very accurate results, so it can only be used.
-
Anonymous users2024-02-03There is no such function formula in Excel developed by Lao Mei. It is recommended to find a perpetual calendar and check it and enter it manually.
-
Anonymous users2024-02-02The web link is not difficult, and the call function comes out, which is very accurate.
I also looked for it online and the test is available. Surprise. Thank you from the bottom of my heart for writing the plugin.
-
Anonymous users2024-02-01There's a calendar thing in the VB control, called month or something, you go and check it out.
-
Anonymous users2024-01-31Isn't the lunar calendar the lunar calendar?
-
Anonymous users2024-01-30Can the landlord add points? I can write one specifically for you!
mid(string a, start looking for the bit value (data b), find the number of digits (data c)) Your function looks like this. >>>More
In fact, this situation is very normal, according to relevant experts, because this is mainly the result of the lunar intercalation, which may occur every 19 years. The reporter consulted relevant information and learned that the number of days in the lunar calendar is determined according to the cycle of the moon's movement, and there are only 354 3672 days in a year; The Earth's orbital cycle around the Sun (return year, solar year) is 365 2422 days. By comparison, the actual number of days in one year of the lunar year is 10 875 days less than that of the solar year, which is almost 11 days, and 209 days less in 19 years. >>>More
Constant function y=k
1.Define the domain r >>>More
Two commandbuttons, two lables, two texts"
private sub command1_click()r = >>>More
1/sqrt(1-x^2)dxi.e. (arcsinx).'
1/siny)' >>>More