Excel公式转换为JavaScript [英] Excel formula to convert into JavaScript
本文介绍了Excel公式转换为JavaScript的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,
有人可以给我一个这个Excel公式的手,以便将其转换为JAVASCRIPT:=((DAY((DATE(YEAR(A1),1 +个月(A1),1)-1)) - (DAY(A1)))/(DAY((DATE(YEAR(A1),1个月+(A1),1)-2))))+(DATEDIF( A1,B1,m) - 1)+((DAY(B1))/(DAY(DATE(年(B1),1 + MONTH(B1),1)-1)))
到JAVASCRIPT?
谢谢,
Chris
推荐答案
参见< a href =http://www.w3schools.com/jsref/jsref_obj_date.asp> http://www.w3schools.com/jsref/jsref_obj_date.asp [ ^ ]。
感谢您的快速回答,不是我想要的。
我发现了一些更接近我正在寻找的东西,但这段代码给出了几个月和几天的答案:
使用JavaScript计算两个日期之间的年龄/持续时间 [ ^ ]
我需要一个代码来计算两个月之间的差异。
例如,截止日期为20.JUNE.13 - 15.MAY.14,相当于0,36666(自6月起19天)+ JUL + AUG + SEP + OCT + NOV + DEC + JAN + FEB + MAR + APR + 0.48387(自5月起15天)= 10.85053 月。
Thank you for the fast answer, but is not what I was looking for.
I have found out something that is closer to what I'm searching for, but this code gives the answer in months and days:
Calculate Age / Duration Between Two Dates using JavaScript[^]
I need a code that will calculate the difference between two dates in months.
For example the difference in months between 20.JUNE.13 - 15.MAY.14, is equal to 0,36666 (19 days from June)+ JUL+ AUG+ SEP+ OCT+ NOV+ DEC+ JAN+ FEB+ MAR+ APR+ 0.48387 (15 days from MAY) = 10.85053 months.
这篇关于Excel公式转换为JavaScript的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文