如何在表格中计算两个日期的相差天数?
<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">使用</span>WPS Office打开或新建表格，选中需要输出结果的单元格</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">点击</span>“插入函数”，查找并选择函数“DAYS360”，点击“确定”。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">根据需要设置好</span>“开始时间”及“截止时间”。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">公式中</span></span><span style="font-family: 微软雅黑;font-size: 16px">“选项”是指定计算的逻辑值</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">，这里不填写。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px">FALSE或忽略是美国计算法，TRUE是欧洲计算法。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">完成上述操作后点击</span>“确定”即可输出结果</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">注意：按照一年</span> 360 天的算法（每个月以 30 天计，一年共计 12 个月）计算。</span></p><p><br></p><p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/0764c99997a25d1d282bc0c437616040.gif" title="如何在表格中计算两个日期的相差天数.gif" alt="如何在表格中计算两个日期的相差天数.gif"></p><p><br></p>
頁:
[1]