以下为公式源代码,供各位学友参考: {参数: Y1: 1990,2045,2015 M1:1,12,1 D1:1,31,1 Y2: 1990,2045,2015 M2:1,12,1 D2:1,31,1 } TJ1:=(Y1-1900)*10000+M1*100+D1; TJ2:=(Y2-1900)*10000+M2*100+D2; RANGE(FINANCE(42),DATETODAY(MACHINEDATE)-DATETODAY(TJ2),DATETODAY(MACHINEDATE)-DATETODAY(TJ1)); {参数精灵 起: Param#0Param#1Param#2 止: Param#3Param#4Param#5} |
|