问题描述
我找到了一个将日历日期转换成农历日期的excel公式:
I found an excel formula that transforms calendar dates into Chinese lunar dates:
=TEXT(A1,"[$-130000]d/m/yyyy")
说A1是
08/12/2018
公式的输出为
2/11/2018
这是如何工作的?什么是$?什么是$-130000? 关于TEXT的MS帮助文章没有提及.
How does this work? What is $? What is $-130000? The MS's help article on TEXT does not mention this.
我可以使用什么公式进行反向计算，即从阴历到阳历? $+130000不起作用.
What formula can I use to do the reverse calculation, i.e. from lunar calendar to solar calendar? $+130000 does not work.
我刚遇到关于SO的答案，其中说[$ -xxxx]是一些区域设置代码，对我来说很有意义.但是，我找不到任何消息说130000代表什么.
I just came across this answer on SO, which says [$-xxxx] is some locale code, which makes perfect sense to me. However, I cannot find any source says what locale 130000 represents.
推荐答案
如果您仍在寻找有关[$ -130000]代表什么的答案，请在此处查看我的其他答案.
If you are still looking for an answer about what does [$-130000] represent then check out my other answer here.
130000在Excel语言环境代码[$ -130000]是什么意思?
我不确定如何进行逆向转换.如果您尝试执行上述功能的相反操作，那将是...
I am not certain how to do a reverse conversion. If you try to do the reverse of the above function, which would be...
=TEXT(A1, "[$-1010409]d/m/yyyy")
但这只是获取显示的日期，然后将其转换为指定的格式(即，它已经将"A1"中的所有内容视为公历日期)
But this simply takes the presented date, and converts it to the stated format (i.e. it sees whatever in "A1" as a Gregorian date already)
这篇关于$符号在TEXT函数中是什么意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！