c# - 在 C# 中模拟 Excel 的 YearFrac

Question

如何获得与 Excel YearFrac function 相同的结果在我的 C# 应用程序中？

Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.

Answer 1

这是一个很好的snippet .

YearFrac 函数的算法实际上非常复杂。也许 this article可以为您提供更多细节。